Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-00008: ORACLE error 904 encounteredORA-00904: invalid column nameEXP-00000: 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 >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >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" >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 > > AT&T > > Database Administrator > > 816-995-3922 > > wcarle@att.com > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Carle, William T (Bill), NLCIO > > INET: wcarle@att.com > > > > 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: ListGuru@fatcity.com (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 >ctrassens@yahoo.com >ctrassens@hotmail.com >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: ctrassens@yahoo.com > >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: ListGuru@fatcity.com (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: jnair75@hotmail.com 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: ListGuru@fatcity.com (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). Received on Tue Aug 07 2001 - 10:54:29 CDT