Ordonnancement
Sites (frenchs)
Oracle New Downloads
Licence
Search
Global search
Adscomp.databases.oracle Google Group
comp.databases.oracle Google Group
- Free ad-hoc reporting tools
- I am in need of an ad-hoc reporting tool for generating reports from a database on an SQL server. Crystal Reports has all of the functionality I need but the price tag is too high. Are there any free tools out there like crystal (...)
3 June 2008
- why to migrate from infromix to oracle
- Hi all, We are doing an exercise of migrating an application (developed in Informix 4gl) from Informix to Oracle database. Before doing actual migration, we would like to know some of the key advantages of Oracle over Informix. If there are any examples of any company getting benefits (...)
3 June 2008
- Oracle 7.3 v 9.2 client connection problems
- Hi all. I have a need to connect to an Oracle 7.3.3.5 database. I have a user who successfully connects to it with her Oracle 7.3 client. I have an Oracle 9.2 client installed on my machine. I had her send me her tnsnames.ora from her PC. The entry I wanted was as follows (some (...)
3 June 2008
- ORA 7.3 v 9.2 client conneection problems
- Hi all. I have a need to connect to an Oracle 7.3.3.5 database. I have a user who successfully connects to it with her Oracle 7.3 client. I have an Oracle 9.2 client installed on my machine. I had her send me her tnsnames.ora from her PC. The entry I wanted was as follows (some (...)
3 June 2008
- "No size set for variable length data" Oracle update error with empty string in .NET
- Hi - I'm updating an Oracle table with an empty string and getting the error: An unhandled exception of type 'System.Exception' occurred in system.data.dll Additional information: Parameter 'p1': No size set for variable length data type: String. The column is (...)
3 June 2008
- with clause for subquery factoring
- Hi, The following does not return result: with free_space_by_tablespace as ( select sum(bytes)/1024 Kbytes_free, max(bytes)/1024 largest, tablespace_name from sys.dba_free_space group by tablespace_name select * from free_space_by_tablespace (...)
3 June 2008
- Last rites declaration of Ioannes Paulus PP. II (Karol Wojtyla)
- "The unforgiveable sins this earth must confront and overcome are Nationalism, capitalism, and hoarding. The idea of every nation should be forgot, price should be struck from the commons, and princes should be seen for the devils they are. The sins include our church, secret societies, (...)
3 June 2008
- DW + Oracle: see tbls w/ recordset but not insert
- Hi, I'm using dreamweaver to do some asp development with an oracle database. I'm having trouble seeing tables that are in my own schema. I can see several other tables in other schemas, but not my own - this is in the dreamweaver table browser. If I do an 'advanced' (...)
3 June 2008
- Rules Engine
- I am looking for a rules engine, based on Oracle, that is as generic as possible. I don't even know if such a beast exists. The application area is saturated by nested ifs, else and lookup in various tables. I want to try and consolidate all of that and hope that there is a more (...)
3 June 2008
- Oracle Reports JDBCPDS
- Hi, I'm trying to setup a JDBCPDS (Pluggable Data Source) to a MySQL database so that I can use Oracle Reports to report against that database. Has anyone successfully setup a JDBCPDS to MySQL via Oracle Reports? If you have, can you send me the details of what you did. I've (...)
3 June 2008
- Changing db_block_size
- Hi, I have Oracle9i on HP-UX. I am using raw partitions for Oracle. If I change db_block_size, will it affect performance or scalability of Oracle? Thanks, Tejaswini
3 June 2008
- 实现财务自由与 在家工作的梦想 ? Work from Ho me and Get Financial Freedom
- 实现财务自由与在家工作的梦想? Work from Home and Get Financial Freedom 我们了解忙碌的您，不会愿意再牺牲与
3 June 2008
- The Greatest News Ever!
- [link] << The Greatest News Ever!
3 June 2008
- Great News Blog!
- [link] << Great News Blog!
3 June 2008
- Which Operation of the Complex SQL is doing full table scan
- Hi I have a very complex sql query and a explain plan. I found there is a full table scan in ID=9 9 8 TABLE ACCESS (FULL) OF 'F_LOTTXNHIST' (Cost=84573 Card=185892 Bytes=7063896) How can I correlate which part of the SQL statement is running on full table scan. Please see (...)
3 June 2008
- Fast bulk load with API?
- Hi all- I have a windows service (like a Unix daemon) that loads flat files into an 8.1.7 database. I use Oracle Objects for this, but it takes a very long time, especially with CLOBs to do > 10,000 records. I would use SQL Loader, but because this is a service, I can't spawn (...)
3 June 2008
- Is it possible to delete parts of a table without using rollback??
- I want to delete just parts of tables, so I can't use 'TRUNCATE'. As I want to delete about millions of lines, I need a very big rollback segment. The best way would be to delete without using rollback because the delete really takes a lot of time copying all data into the (...)
3 June 2008
- Help needed for Database Replication
- Hi All, I am currently handling a J2EE application with the Application server as Weblogic 7.0 SP2 and Database on Oracle 9.2.1.0. The client wants to setup a test environment, and as the application is mission-critical, it would be of great help if the production and test DB are in (...)
3 June 2008
- Performance difference between Windows and Solaris 10g
- Hy! We got the same datamodell on Solaris and on WindowsXP. But there is a mojor difference in the Performance. The database on Windows is much faster than the one on Solaris although the Solaris machine is a dual processor. The initialization parameters are also correct, I hope so (...)
3 June 2008
- Why you don't usually get answers here ...
- People periodically post questions to the comp.databases.oracle newsgroup and may wonder why there are very few responses. Basically, comp.databases.oracle is NOT a newsgroup anymore, but rather just a pointer or place holder to the correct newsgroups. Several years ago, the group (...)
3 June 2008
- SQL - Select and filtering whereby a date is not null.
- I have a particular problem: I am working at a client site where they have the following oracle system: Oracle7 Server Release 7.3.3.0.0 - Production Release PL/SQL Release 2.3.3.0.0 - Production I am trying to select Person_id's filtering by where a date is not null see below: (...)
3 June 2008
- Forms Builder speed
- Hi all. Our company have a number of sites where I am required to work. When at my "home" site Forms Builder works OK. When at another site, it slows to a crawl due to a screen redraw every time I do anything, even just click on a Record Group or Canvass. Every button redraws. If on a (...)
3 June 2008
- (",) Do You Want To Know For Sure You Are Going To Heaven?
- [link] << Click On Link
3 June 2008
- Sequence Error ORA-02287
- Hi, After an insert using nextval I try: SELECT * FROM tblClients WHERE fldclient_id = (SELECT client_id_seq.currval from Dual) and get: java.sql.SQLException: ORA-02287: sequence number not allowed here I've read lots on sequence's etc and I can't see why I cant get the (...)
3 June 2008
- Order By Performance Problem on View
- I have a view that contains the following SQL1 and it takes about 500ms to run with Explain Plan EXP1. However, if I add an order by clause(e.g. select * from view1 order by ID desc), it will then take about 3 mins to return. The explain plan for the query with the order by clause is as (...)
3 June 2008
- How to build database to support user-specified entities and attributes?
- I have a database that tracks players for children's sports clubs. I have included representative DDL for this database at the end of this post. A single instance of this database supports multiple clubs. I would like to add support for letting each club define and store custom (...)
3 June 2008
- Pivot query in oracle- Please help!!
- I have a table with following values City STATE COLOR REGION city1 Texas White SW city2 Texas Gray SW city3 Texas Gray SW city4 Nevada Gray PAC c5 Texas Yellow SW c6 Florida Yellow SE c7 Missouri Orange W c8 Texas Orange SW I am trying to create a report which looks like: (...)
3 June 2008
- Read Text file into Oracle Reports
- Rishka Mar 17, 5:40 am show options Newsgroups: comp.databases.oracle.tools Local: Thurs, Mar 17 2005 5:40 am Reply | Reply to Author | Forward | Print | Individual Message | Show original | Remove | Report Abuse Hello I a newbie to Oracle Reports, our requirement is to write a (...)
3 June 2008
- OCI library for Oracle 8.1.7.4.0 on OpenVMS
- Hi, I'm working for the backup application. Currently we need to support Oracle8i backups for our application. We are having OCI* calls from our code. We are using Recovery Manager: Release 8.1.7.4.0 - Production version in our system. We have installed the oracle 81740 patch. (...)
3 June 2008
- Follow up to previous post
- I just realized that I meant to say "How to do this without a correlated subquery". Sorry, folks
3 June 2008
- SQL Query
- This is probably easy and I'm missing it because I'm a little sleep-deprived this month, but: given the following table 'test': name group salary ----- ----------- ------ unique medium cardinality How can I select the name(s) for each group that have the highest (...)
3 June 2008
- AVG and SUM in subquery return wrong values
- Hi I have the following query aggregating values over a column and creating the sum over another column. Here everything works out fine. SELECT c.timestamp, AVG(c.response) as response, SUM(c.quantity) as quantity, c.trans FROM tbl_repo01_dest c GROUP BY c.trans, c.timestamp No (...)
3 June 2008
- Invalid attribute/identifier error
- HI , My application runs fine when I am using SQL Server 2000 as its db, but it gives a message "Invalid attribute/identifier" error when the db is Oracle . Any help in this matter would be appreciated . Thanks , (...)
3 June 2008
- XML joining Nested resultsets
- HI, I have an XMLType column that has the following XML structure: Item> Item> Item> Item>
3 June 2008
- How to build database to support user-specified attributes?
- I have a database that tracks players for children's sports clubs. I have included representative DDL for this database at the end of this post. A single instance of this database supports multiple clubs. I would like to add support for letting each club define and store custom (...)
3 June 2008
- port/protocol for sqlplus connectivity
- Hello, We were having trouble connecting to Oracle 8.1.7 running on a Solaris machine. We assumed this was because a firewall blocked access to port 1521. When we requested that our IT group open up that port, we were asked, which protocol, UDP or TCP? Does protocol matter? What (...)
3 June 2008
- Problems: Oracle 9 Installation and Windows XP SP2
- Hello, i have a big problems, to install oracle 9i v9.2 Server to my "Windows XP" with Service Pack 2 and all security and other updates from Microsoft. The "Universall Installer" (Standard Edition is Selected and only Software is Selected) throws an exception, during the installation (...)
3 June 2008
- Oracle 9 Installation Problems under Windows XP SP2
- Hello, i have a big problems, to install oracle 9i v9.2 Server to my "Windows XP" with Service Pack 2 and all security and other updates from Microsoft. The "Universall Installer" (Standard Edition is Selected and only Software is Selected) throws an exception, during the installation (...)
3 June 2008
- install oracle 8.1.7 and developer 6i under same oracle home.
- Hello EveryBody, I had installed Oracle client 8.1.7. Now I want to install Developer 6i under the Oracle 8.1.7 home. When I tried to install this , it was giving message "the location specified, D:\ is already in use as an Oracle Home for 'Oracle 816 Production'. It cannot be (...)
3 June 2008
- Installing Oracle on Linux Redhat
- I was trying to install Oracle on a Linux box with Redhat and got an error message saying the OS had to be Redhat 2.1 or 3.0 (plus some other non-Redhat versions). Does anyone know what I have to do bypass this since I am clearly using a higher version of (...)
3 June 2008
- Converting a bare number to an interval and back
- Salve. I have an application in which I would like to convert a number of seconds into an INTERVAL DAY TO SECOND value and, later, back to a number of seconds. For reasons relating to inter-database portability, I'd like to do this in a stored function, not in the database client (...)
3 June 2008
- ORA-29531 - And the method is declared both PUBLIC and STATIC
- Could someone be of assistance and show me the problem with the following code? I have researched Metalink regarding ORA-29531, and the most common cause of this error is the failure to declare the method "public" and "static". I have done both here and still have the same error: Java (...)
3 June 2008
- External SQL functions exported by DLLs
- We have a few rather advanced calculation routines developed in C++. Currently we are using a Sybase ASA database for our app. and these routines are accessible by so called external functions exported by a DLL (dynamic link library) that we wrote in C++. Sybase supports this quite (...)
3 June 2008
- Oracle Discoverer Newbie...
- Hi ! I am trying to learn how to use Oracle Discoverer. I have worked with databases, like Oracle for several years, but i am new to Discoverer. Does anybody know a place to download an "Oracle Discoverer for Dummies ...", or some other good tutorial for a newbie like me. Regards, (...)
3 June 2008
- How to debug .pc file instead of debug generated .c file?
- Anybody knows if it is possible to use gdb/dbx to debug .pc file instead of generated .c file? Thanks
3 June 2008
- PL SQL Cursor beginner
- Hi I'm beginning with PL SQL and try to learn cursors usage I get ora 920 with this on line "WHERE WHERE_NORME " What i'm trying to do is to fetch where conditions stored in a table, and reuse it in dml order in my cursor.. but I must have missed somethin ? any pl sql killer (...)
3 June 2008
- Aarrrgh - this is NOT the place to ask!!
- There is again a rash of people asking question in comp.databases.oracle and these people are likely disappointed at the lack of responses. Please note that this is not an official news group. Back in the late 90s, the Oracle user community decided to officially split this into several (...)
3 June 2008
- Flashback over database link
- Hello out there, this morning I had to get some rows via flashback query. Since my undo retention is just 3h, the undo segments were already aged out. But I have a physical standby database that is mounted read only during daytime for report processing etc. On this one the old data is (...)
3 June 2008
- how to do dbms_application_info.set_module from JDBC code
- Hi, I want to use the Oracle dbms_application_module's set_module and set_action functionality for tracing my calls. However my client uses JDBC to connect. I can't find how I can make sure the SQL queries done from JDBC are used with the correct module set. Has anyone ever (...)
3 June 2008
- Re: Spotlight For Oracle
- The quest help is pretty good as are the drilldowns for each item dan
3 June 2008