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...

Marcus

03-30-2005 12:07 PM
GreyBeard

Trying to convert timestamp data to date data (without the time in hours/mins/secs), does only seem to work with TO_DATE(mydate; 'yyyymmdd'). But I...

Bob

03-29-2005 07:17 PM
Walt

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...

Stephen Walsh

03-29-2005 01:13 AM
Stephen Walsh

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...

Tejaswini

03-29-2005 12:53 AM
Tejaswini

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....

Gert Schumann

03-24-2005 04:34 PM
Mark.Powell@eds.com

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...

tachoknight@gmail.com

03-23-2005 08:52 PM
Jim Kennedy

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...

Putz Ronald

03-23-2005 04:21 AM
Sameer

People periodically post questions to the comp.databases.oracle newsgroup and may wonder why there are very few responses. Basically,...

GreyBeard

03-22-2005 10:23 AM
GreyBeard

People periodically post questions to the comp.databases.oracle newsgroup and may wonder why there are very few responses. Basically,...

GreyBeard

03-22-2005 10:22 AM
GreyBeard

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 -...

Kal

03-22-2005 09:54 AM
Kal

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,...

ernest.dale@timet.com

03-22-2005 08:15 AM
ernest.dale@timet.com

Hi, After an insert using nextval I try: SELECT * FROM tblClients WHERE fldclient_id = (SELECT client_id_seq.currval from Dual) and get:

james.kennedy@students.plymouth.ac.uk

03-21-2005 09:40 AM
jfk303

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....

Scott

03-18-2005 10:50 AM
Mark.Powell@eds.com

I just realized that I meant to say "How to do this without a correlated subquery". Sorry, folks

jared

03-17-2005 11:15 AM
jared

I have a table with following...

longhorntx

03-17-2005 09:49 AM
longhorntx

Rishka Mar 17, 5:40 am show options Newsgroups: comp.databases.oracle.tools From: "Rishka" <ris... (AT) webmail (DOT) co.za> - Find messages...

rishka@webmail.co.za

03-17-2005 08:57 AM
GreyBeard

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...

Nagi

03-17-2005 12:48 AM
Nagi

Hi I have the following query aggregating values over a column and creating the sum over another column. Here everything works out fine. SELECT...

marc.daetwyler@bawag.com

03-15-2005 02:06 PM
Ed Prochak

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...

ghosh.sujay@gmail.com

03-15-2005 10:55 AM
Mark C. Stock

HI, I have an XMLType column that has the following XML structure: <Client> <Report id = "01"> <Item id = "01" Description = ",a.mdfbnelt;yuk"...

ccote_msl@yahoo.com

03-15-2005 07:57 AM
GreyBeard

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...

laredotornado@zipmail.com

03-14-2005 02:58 PM
Frank van Bortel

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...

black hawk

03-14-2005 11:58 AM
Frank van Bortel

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 ,...

vikas.rijhwani@gmail.com

03-14-2005 11:26 AM
Eric de Redelijkheid

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...

black hawk

03-14-2005 08:23 AM
black hawk

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...

tim@nocomment.com

03-14-2005 03:02 AM
Bašiæ Alen

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...

mrique

03-12-2005 09:17 AM
mrique

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...

angrybaldguy@gmail.com

03-12-2005 07:36 AM
Frank van Bortel

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...

jkstexas2001@yahoo.com

03-11-2005 03:08 PM
GreyBeard

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...

Peter Sullvan

03-11-2005 08:49 AM
Peter Sullvan

Hello people! I am a bit puzzled here so any help will be much appreciated. Here is the situation: I have a query which selects all the data based...

DMina@laiki.com

03-11-2005 04:22 AM
Bobiander

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...

Ole Hansen

03-10-2005 04:18 PM
GreyBeard

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...

Lothar Armbr?ster

03-10-2005 04:02 AM
Carlos

Anybody knows if it is possible to use gdb/dbx to debug .pc file instead of generated .c file? Thanks

modemer

03-09-2005 05:46 PM
modemer

Hi, I am looking for PL/SQL examples for beginners. Can anyone help me find few??? Thanks in advance pavan

Pavan

03-09-2005 12:18 PM
George Lewycky

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...

GreyBeard

03-09-2005 08:14 AM
GreyBeard

I'm looking for a link where I can find details about pro*c compilers for windows. Anyone can help? Thanks

Golan

03-09-2005 07:59 AM
GreyBeard

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...

Digvijay Lamba

03-08-2005 09:08 PM
Digvijay Lamba

Hi, I have started using Spotlight to monitor a few oracle 8i databases and wonder whether there are any papers detailing what all the indicators...

Jim

03-08-2005 06:39 PM
Daniel

I have two SQL statements: Statement...

Alex

03-08-2005 08:57 AM
Frank van Bortel

I'm looking for a link where I can find details about pro*c compilers for windows. Thanks in advance

Golan

03-08-2005 05:35 AM
Golan

In my research, I want a sample database with SQL triggers in order to validade my testing approach. Unfortunately, I can´t find actual databases...

Plinio Leitao

03-07-2005 03:04 PM
Plinio Leitao

Hi, Can someone please tell me how to open a help file through forms. I have tried the HOST() command which was detailed in a previous topic however...

davidwelch40@yahoo.com

03-07-2005 02:58 PM
Frank van Bortel

Hi Oracle support send me an anual fee with - Product Support - Software Updates I run 9i Oracle Database Standard Edition - Processor Perpetual I...

mrique

03-07-2005 02:57 PM
Frank van Bortel

hi all, I am programming on linux, my program want to connect a oracle database server to do some SQL statement/procedure. But I don't know how to...

baumann.Pan@gmail.com

03-07-2005 07:47 AM
baumann.Pan@gmail.com

Hello, I already succeed to call a stored procedure in Oracle but only simple ones with one output value and several inputs. I don't any idea...

stephane.traumat@gmail.com

03-06-2005 05:32 PM
stephane.traumat@gmail.com

Hi, I have an Oracle 8i instance which has somehow managed to store the 29th of February 2005 in a date field. As 2005 isn't a leap year this is an...

GaudaPrime

03-06-2005 03:43 PM
GaudaPrime

I would like to ask for clarification on the meaning of these two columns. According to the 9i Ref, object_id is the dictionary object number of the...

Jack

03-04-2005 12:57 PM
Jack

Hello, I have a stored procedure and I want to pass it a NUMBER parameter to make a select inside it as the following: SELECT * FROM...

2much4u

03-04-2005 11:37 AM
2much4u

Hi, I have the following problem: We have an Oracle 9.2 with one table "document" which contains a path to the filesystem. If I want to index these...

Nikola Pecigos

03-04-2005 04:49 AM
Frank van Bortel

I have tableA, defined as: field1 varchar2(10), field2 varchar2(10), field3 varchar2(10) I have host variables defined as: v1 pic x(10) varying v2...

Chris

03-03-2005 12:43 PM
jce