Re: Weird -904 Problem
Hi, I appled 8.1.6.3 patch few days back. To my surprise, another instance did not have the same problem after applying the same patch. I got another reply to run $ORACLE_HOME/javavm/install/initdbj.sql as internal user and it worked like a magic!! I am still trying to relate the javavm and export utility ! Thanks to all who replied. Now,I got to close that tar opened with Metalink which is in "work in progress" mode for sometime! Rgds, Jyoti From: Christian Trassens <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Weird -904 Problem Date: Tue, 07 Aug 2001 11:05:42 -0800 Probably you need to run the catexp.sql again. This is 100% if you applied a patch. Even if you don't try running the catexp.sql again. Also the error during export depends on where you have had it. I mean whether it has been in one of your tables or in sys/system objects. Regards. --- Jyoti N <[EMAIL PROTECTED]>wrote: style='background-color:' Hi, I got a similar problem in my test database while trying to do an export.Opened a tar with Oracle , but not much luck yet. I get the following error: EXP-8: ORACLE error 904 encounteredORA-00904: invalid column nameEXP-0: Export terminated unsuccessfully. No idea why this happened?I am not sure if this is connected to the 904 mentioned here. Rgds, Jyoti "-//W3C//DTD HTML 4.0 Transitional//EN" From: Christian Trassens <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Weird -904 Problem Date: Tue, 07 Aug 2001 06:06:26 -0800 Do you create the table with any strange symbol or in lowercase or mixing lower and upper or within spaces..?, As f.e.: create table weird ( "Weird Field" NUMBER ); Regards. --- "Carle, William T (Bill), NLCIO" <[EMAIL PROTECTED]> wrote: Howdy, I had an interesting situation today. The application was trying to insert rows into a table and was getting a -904 error for invalid column. The actual problem was that the tablespace containing the indexes was full and the index was unable to extend. That was in the alert log. However, when doing a tkprof on their sql statements, it showed every sql statement getting a -904. It doesn't seem like it should do that. Has anyone seen this before? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get your FREE download of MSN Explorer at href='http://go.msn.com/bql/hmtag_itl_EN.asp'http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti N INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the messa
Re: Weird -904 Problem
Do you create the table with any strange symbol or in lowercase or mixing lower and upper or within spaces..?, As f.e.: create table weird ( Weird Field NUMBER ); Regards. --- Carle, William T (Bill), NLCIO [EMAIL PROTECTED] wrote: Howdy, I had an interesting situation today. The application was trying to insert rows into a table and was getting a -904 error for invalid column. The actual problem was that the tablespace containing the indexes was full and the index was unable to extend. That was in the alert log. However, when doing a tkprof on their sql statements, it showed every sql statement getting a -904. It doesn't seem like it should do that. Has anyone seen this before? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Weird -904 Problem
Hi, I got a similar problem in my test database while trying to do an export.Opened a tar with Oracle , but not much luck yet. I get the following error: EXP-8: ORACLE error 904 encounteredORA-00904: invalid column nameEXP-0: Export terminated unsuccessfully. No idea why this happened?I am not sure if this is connected to the 904 mentioned here. Rgds, Jyoti From: Christian Trassens <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Weird -904 Problem Date: Tue, 07 Aug 2001 06:06:26 -0800 Do you create the table with any strange symbol or in lowercase or mixing lower and upper or within spaces..?, As f.e.: create table weird ( "Weird Field" NUMBER ); Regards. --- "Carle, William T (Bill), NLCIO" <[EMAIL PROTECTED]> wrote: Howdy, I had an interesting situation today. The application was trying to insert rows into a table and was getting a -904 error for invalid column. The actual problem was that the tablespace containing the indexes was full and the index was unable to extend. That was in the alert log. However, when doing a tkprof on their sql statements, it showed every sql statement getting a -904. It doesn't seem like it should do that. Has anyone seen this before? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti N INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Weird -904 Problem
Probably you need to run the catexp.sql again. This is 100% if you applied a patch. Even if you don't try running the catexp.sql again. Also the error during export depends on where you have had it. I mean whether it has been in one of your tables or in sys/system objects. Regards. --- Jyoti N [EMAIL PROTECTED] wrote: HR htmldiv style='background-color:'PBRBRHi,/P PI got a similar problem in my test database while trying to do an export.Opened a tar with Oracle , but not much luck yet. /P PI get the following error:/P PEXP-8: ORACLE error 904 encounteredBRORA-00904: invalid column nameBREXP-0: Export terminated unsuccessfully./P PNo idea why this happened?I am not sure if this is connected to the 904 mentioned here./P PRgds,/P PJyoti/P PBRBRBRnbsp;/P!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN DIV/DIV DIV/DIV DIV/DIV META content=MSHTML 5.50.4134.600 name=GENERATOR DIV/DIV DIV/DIV DIV/DIV DIVnbsp;/DIV DIV/DIV DIV/DIV DIV/DIV DIV/DIVgt;From: Christian Trassens [EMAIL PROTECTED] DIV/DIVgt;Reply-To: [EMAIL PROTECTED] DIV/DIVgt;To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] DIV/DIVgt;Subject: Re: Weird -904 Problem DIV/DIVgt;Date: Tue, 07 Aug 2001 06:06:26 -0800 DIV/DIVgt; DIV/DIVgt;Do you create the table with any strange symbol or in DIV/DIVgt;lowercase or mixing lower and upper or within DIV/DIVgt;spaces..?, As f.e.: DIV/DIVgt; DIV/DIVgt;create table weird ( Weird Field NUMBER ); DIV/DIVgt; DIV/DIVgt;Regards. DIV/DIVgt; DIV/DIVgt;--- Carle, William T (Bill), NLCIO [EMAIL PROTECTED] DIV/DIVgt;wrote: DIV/DIVgt; gt; Howdy, DIV/DIVgt; gt; DIV/DIVgt; gt; I had an interesting situation today. The DIV/DIVgt; gt; application was trying to DIV/DIVgt; gt; insert rows into a table and was getting a -904 DIV/DIVgt; gt; error for invalid column. DIV/DIVgt; gt; The actual problem was that the tablespace DIV/DIVgt; gt; containing the indexes was full DIV/DIVgt; gt; and the index was unable to extend. That was in the DIV/DIVgt; gt; alert log. However, when DIV/DIVgt; gt; doing a tkprof on their sql statements, it showed DIV/DIVgt; gt; every sql statement DIV/DIVgt; gt; getting a -904. It doesn't seem like it should do DIV/DIVgt; gt; that. Has anyone seen this DIV/DIVgt; gt; before? DIV/DIVgt; gt; DIV/DIVgt; gt; DIV/DIVgt; gt; Bill Carle DIV/DIVgt; gt; ATamp;T DIV/DIVgt; gt; Database Administrator DIV/DIVgt; gt; 816-995-3922 DIV/DIVgt; gt; [EMAIL PROTECTED] DIV/DIVgt; gt; DIV/DIVgt; gt; -- DIV/DIVgt; gt; Please see the official ORACLE-L FAQ: DIV/DIVgt; gt; http://www.orafaq.com DIV/DIVgt; gt; -- DIV/DIVgt; gt; Author: Carle, William T (Bill), NLCIO DIV/DIVgt; gt; INET: [EMAIL PROTECTED] DIV/DIVgt; gt; DIV/DIVgt; gt; Fat City Network Services -- (858) 538-5051 FAX: DIV/DIVgt; gt; (858) 538-5051 DIV/DIVgt; gt; San Diego, California -- Public Internet DIV/DIVgt; gt; access / Mailing Lists DIV/DIVgt; gt; DIV/DIVgt; DIV/DIVgt; gt; To REMOVE yourself from this mailing list, send an DIV/DIVgt; gt; E-Mail message DIV/DIVgt; gt; to: [EMAIL PROTECTED] (note EXACT spelling of DIV/DIVgt; gt; 'ListGuru') and in DIV/DIVgt; gt; the message BODY, include a line containing: UNSUB DIV/DIVgt; gt; ORACLE-L DIV/DIVgt; gt; (or the name of mailing list you want to be removed DIV/DIVgt; gt; from). You may DIV/DIVgt; gt; also send the HELP command for other information DIV/DIVgt; gt; (like subscribing). DIV/DIVgt; DIV/DIVgt; DIV/DIVgt;= DIV/DIVgt;Eng. Christian Trassens DIV/DIVgt;Senior DBA DIV/DIVgt;Systems Engineer DIV/DIVgt;[EMAIL PROTECTED] DIV/DIVgt;[EMAIL PROTECTED] DIV/DIVgt;Phone : 541149816062 DIV/DIVgt; DIV/DIVgt;__ DIV/DIVgt;Do You Yahoo!? DIV/DIVgt;Make international calls for as low as $.04/minute with Yahoo! Messenger DIV/DIVgt;http://phonecard.yahoo.com/ DIV/DIVgt;-- DIV/DIVgt;Please see the official ORACLE-L FAQ: http://www.orafaq.com DIV/DIVgt;-- DIV/DIVgt;Author: Christian Trassens DIV/DIVgt; INET: [EMAIL PROTECTED] DIV/DIVgt; DIV/DIVgt;Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 DIV/DIVgt;San Diego, California -- Public Internet access / Mailing Lists DIV/DIVgt; DIV/DIVgt;To REMOVE yourself from this mailing list, send an E-Mail message DIV/DIVgt;to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in DIV/DIVgt;the message BODY, include a line containing: UNSUB ORACLE-L DIV/DIVgt;(or the name of mailing list you want to be removed from). You may DIV/DIVgt;also send the HELP command for other information (like subscribing). DIV/DIV/divbr clear=allhrGet your FREE download of MSN Explorer at a href='http://go.msn.com/bql/hmtag_itl_EN.asp'http://explorer.msn.com/abr/html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti N INET: [EMAIL PROTECTED] Fat City
Re: Weird -904 Problem
Probably you need to run the catexp.sql again. This is 100% if you applied a patch. Even if you don't try running the catexp.sql again. Also the error during export depends on where you have had it. I mean whether it has been in one of your tables or in sys/system objects. Regards. --- Jyoti N [EMAIL PROTECTED] wrote: HR htmldiv style='background-color:'PBRBRHi,/P PI got a similar problem in my test database while trying to do an export.Opened a tar with Oracle , but not much luck yet. /P PI get the following error:/P PEXP-8: ORACLE error 904 encounteredBRORA-00904: invalid column nameBREXP-0: Export terminated unsuccessfully./P PNo idea why this happened?I am not sure if this is connected to the 904 mentioned here./P PRgds,/P PJyoti/P PBRBRBRnbsp;/P!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN DIV/DIV DIV/DIV DIV/DIV META content=MSHTML 5.50.4134.600 name=GENERATOR DIV/DIV DIV/DIV DIV/DIV DIVnbsp;/DIV DIV/DIV DIV/DIV DIV/DIV DIV/DIVgt;From: Christian Trassens [EMAIL PROTECTED] DIV/DIVgt;Reply-To: [EMAIL PROTECTED] DIV/DIVgt;To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] DIV/DIVgt;Subject: Re: Weird -904 Problem DIV/DIVgt;Date: Tue, 07 Aug 2001 06:06:26 -0800 DIV/DIVgt; DIV/DIVgt;Do you create the table with any strange symbol or in DIV/DIVgt;lowercase or mixing lower and upper or within DIV/DIVgt;spaces..?, As f.e.: DIV/DIVgt; DIV/DIVgt;create table weird ( Weird Field NUMBER ); DIV/DIVgt; DIV/DIVgt;Regards. DIV/DIVgt; DIV/DIVgt;--- Carle, William T (Bill), NLCIO [EMAIL PROTECTED] DIV/DIVgt;wrote: DIV/DIVgt; gt; Howdy, DIV/DIVgt; gt; DIV/DIVgt; gt; I had an interesting situation today. The DIV/DIVgt; gt; application was trying to DIV/DIVgt; gt; insert rows into a table and was getting a -904 DIV/DIVgt; gt; error for invalid column. DIV/DIVgt; gt; The actual problem was that the tablespace DIV/DIVgt; gt; containing the indexes was full DIV/DIVgt; gt; and the index was unable to extend. That was in the DIV/DIVgt; gt; alert log. However, when DIV/DIVgt; gt; doing a tkprof on their sql statements, it showed DIV/DIVgt; gt; every sql statement DIV/DIVgt; gt; getting a -904. It doesn't seem like it should do DIV/DIVgt; gt; that. Has anyone seen this DIV/DIVgt; gt; before? DIV/DIVgt; gt; DIV/DIVgt; gt; DIV/DIVgt; gt; Bill Carle DIV/DIVgt; gt; ATamp;T DIV/DIVgt; gt; Database Administrator DIV/DIVgt; gt; 816-995-3922 DIV/DIVgt; gt; [EMAIL PROTECTED] DIV/DIVgt; gt; DIV/DIVgt; gt; -- DIV/DIVgt; gt; Please see the official ORACLE-L FAQ: DIV/DIVgt; gt; http://www.orafaq.com DIV/DIVgt; gt; -- DIV/DIVgt; gt; Author: Carle, William T (Bill), NLCIO DIV/DIVgt; gt; INET: [EMAIL PROTECTED] DIV/DIVgt; gt; DIV/DIVgt; gt; Fat City Network Services -- (858) 538-5051 FAX: DIV/DIVgt; gt; (858) 538-5051 DIV/DIVgt; gt; San Diego, California -- Public Internet DIV/DIVgt; gt; access / Mailing Lists DIV/DIVgt; gt; DIV/DIVgt; DIV/DIVgt; gt; To REMOVE yourself from this mailing list, send an DIV/DIVgt; gt; E-Mail message DIV/DIVgt; gt; to: [EMAIL PROTECTED] (note EXACT spelling of DIV/DIVgt; gt; 'ListGuru') and in DIV/DIVgt; gt; the message BODY, include a line containing: UNSUB DIV/DIVgt; gt; ORACLE-L DIV/DIVgt; gt; (or the name of mailing list you want to be removed DIV/DIVgt; gt; from). You may DIV/DIVgt; gt; also send the HELP command for other information DIV/DIVgt; gt; (like subscribing). DIV/DIVgt; DIV/DIVgt; DIV/DIVgt;= DIV/DIVgt;Eng. Christian Trassens DIV/DIVgt;Senior DBA DIV/DIVgt;Systems Engineer DIV/DIVgt;[EMAIL PROTECTED] DIV/DIVgt;[EMAIL PROTECTED] DIV/DIVgt;Phone : 541149816062 DIV/DIVgt; DIV/DIVgt;__ DIV/DIVgt;Do You Yahoo!? DIV/DIVgt;Make international calls for as low as $.04/minute with Yahoo! Messenger DIV/DIVgt;http://phonecard.yahoo.com/ DIV/DIVgt;-- DIV/DIVgt;Please see the official ORACLE-L FAQ: http://www.orafaq.com DIV/DIVgt;-- DIV/DIVgt;Author: Christian Trassens DIV/DIVgt; INET: [EMAIL PROTECTED] DIV/DIVgt; DIV/DIVgt;Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 DIV/DIVgt;San Diego, California -- Public Internet access / Mailing Lists DIV/DIVgt; DIV/DIVgt;To REMOVE yourself from this mailing list, send an E-Mail message DIV/DIVgt;to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in DIV/DIVgt;the message BODY, include a line containing: UNSUB ORACLE-L DIV/DIVgt;(or the name of mailing list you want to be removed from). You may DIV/DIVgt;also send the HELP command for other information (like subscribing). DIV/DIV/divbr clear=allhrGet your FREE download of MSN Explorer at a href='http://go.msn.com/bql/hmtag_itl_EN.asp'http://explorer.msn.com/abr/html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti N INET: [EMAIL PROTECTED] Fat City
Re: Weird -904 Problem
Probably you need to run the catexp.sql again. This is 100% if you applied a patch. Even if you don't try running the catexp.sql again. Also the error during export depends on where you have had it. I mean whether it has been in one of your tables or in sys/system objects. Regards. --- Jyoti N [EMAIL PROTECTED] wrote: HR htmldiv style='background-color:'PBRBRHi,/P PI got a similar problem in my test database while trying to do an export.Opened a tar with Oracle , but not much luck yet. /P PI get the following error:/P PEXP-8: ORACLE error 904 encounteredBRORA-00904: invalid column nameBREXP-0: Export terminated unsuccessfully./P PNo idea why this happened?I am not sure if this is connected to the 904 mentioned here./P PRgds,/P PJyoti/P PBRBRBRnbsp;/P!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN DIV/DIV DIV/DIV DIV/DIV META content=MSHTML 5.50.4134.600 name=GENERATOR DIV/DIV DIV/DIV DIV/DIV DIVnbsp;/DIV DIV/DIV DIV/DIV DIV/DIV DIV/DIVgt;From: Christian Trassens [EMAIL PROTECTED] DIV/DIVgt;Reply-To: [EMAIL PROTECTED] DIV/DIVgt;To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] DIV/DIVgt;Subject: Re: Weird -904 Problem DIV/DIVgt;Date: Tue, 07 Aug 2001 06:06:26 -0800 DIV/DIVgt; DIV/DIVgt;Do you create the table with any strange symbol or in DIV/DIVgt;lowercase or mixing lower and upper or within DIV/DIVgt;spaces..?, As f.e.: DIV/DIVgt; DIV/DIVgt;create table weird ( Weird Field NUMBER ); DIV/DIVgt; DIV/DIVgt;Regards. DIV/DIVgt; DIV/DIVgt;--- Carle, William T (Bill), NLCIO [EMAIL PROTECTED] DIV/DIVgt;wrote: DIV/DIVgt; gt; Howdy, DIV/DIVgt; gt; DIV/DIVgt; gt; I had an interesting situation today. The DIV/DIVgt; gt; application was trying to DIV/DIVgt; gt; insert rows into a table and was getting a -904 DIV/DIVgt; gt; error for invalid column. DIV/DIVgt; gt; The actual problem was that the tablespace DIV/DIVgt; gt; containing the indexes was full DIV/DIVgt; gt; and the index was unable to extend. That was in the DIV/DIVgt; gt; alert log. However, when DIV/DIVgt; gt; doing a tkprof on their sql statements, it showed DIV/DIVgt; gt; every sql statement DIV/DIVgt; gt; getting a -904. It doesn't seem like it should do DIV/DIVgt; gt; that. Has anyone seen this DIV/DIVgt; gt; before? DIV/DIVgt; gt; DIV/DIVgt; gt; DIV/DIVgt; gt; Bill Carle DIV/DIVgt; gt; ATamp;T DIV/DIVgt; gt; Database Administrator DIV/DIVgt; gt; 816-995-3922 DIV/DIVgt; gt; [EMAIL PROTECTED] DIV/DIVgt; gt; DIV/DIVgt; gt; -- DIV/DIVgt; gt; Please see the official ORACLE-L FAQ: DIV/DIVgt; gt; http://www.orafaq.com DIV/DIVgt; gt; -- DIV/DIVgt; gt; Author: Carle, William T (Bill), NLCIO DIV/DIVgt; gt; INET: [EMAIL PROTECTED] DIV/DIVgt; gt; DIV/DIVgt; gt; Fat City Network Services -- (858) 538-5051 FAX: DIV/DIVgt; gt; (858) 538-5051 DIV/DIVgt; gt; San Diego, California -- Public Internet DIV/DIVgt; gt; access / Mailing Lists DIV/DIVgt; gt; DIV/DIVgt; DIV/DIVgt; gt; To REMOVE yourself from this mailing list, send an DIV/DIVgt; gt; E-Mail message DIV/DIVgt; gt; to: [EMAIL PROTECTED] (note EXACT spelling of DIV/DIVgt; gt; 'ListGuru') and in DIV/DIVgt; gt; the message BODY, include a line containing: UNSUB DIV/DIVgt; gt; ORACLE-L DIV/DIVgt; gt; (or the name of mailing list you want to be removed DIV/DIVgt; gt; from). You may DIV/DIVgt; gt; also send the HELP command for other information DIV/DIVgt; gt; (like subscribing). DIV/DIVgt; DIV/DIVgt; DIV/DIVgt;= DIV/DIVgt;Eng. Christian Trassens DIV/DIVgt;Senior DBA DIV/DIVgt;Systems Engineer DIV/DIVgt;[EMAIL PROTECTED] DIV/DIVgt;[EMAIL PROTECTED] DIV/DIVgt;Phone : 541149816062 DIV/DIVgt; DIV/DIVgt;__ DIV/DIVgt;Do You Yahoo!? DIV/DIVgt;Make international calls for as low as $.04/minute with Yahoo! Messenger DIV/DIVgt;http://phonecard.yahoo.com/ DIV/DIVgt;-- DIV/DIVgt;Please see the official ORACLE-L FAQ: http://www.orafaq.com DIV/DIVgt;-- DIV/DIVgt;Author: Christian Trassens DIV/DIVgt; INET: [EMAIL PROTECTED] DIV/DIVgt; DIV/DIVgt;Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 DIV/DIVgt;San Diego, California -- Public Internet access / Mailing Lists DIV/DIVgt; DIV/DIVgt;To REMOVE yourself from this mailing list, send an E-Mail message DIV/DIVgt;to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in DIV/DIVgt;the message BODY, include a line containing: UNSUB ORACLE-L DIV/DIVgt;(or the name of mailing list you want to be removed from). You may DIV/DIVgt;also send the HELP command for other information (like subscribing). DIV/DIV/divbr clear=allhrGet your FREE download of MSN Explorer at a href='http://go.msn.com/bql/hmtag_itl_EN.asp'http://explorer.msn.com/abr/html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti N INET: [EMAIL PROTECTED] Fat City
Weird -904 Problem
Howdy, I had an interesting situation today. The application was trying to insert rows into a table and was getting a -904 error for invalid column. The actual problem was that the tablespace containing the indexes was full and the index was unable to extend. That was in the alert log. However, when doing a tkprof on their sql statements, it showed every sql statement getting a -904. It doesn't seem like it should do that. Has anyone seen this before? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
