From ctrassens@yahoo.com Tue, 07 Aug 2001 11:13:55 -0700 From: Christian Trassens Date: Tue, 07 Aug 2001 11:13:55 -0700 Subject: Re: Weird -904 Problem Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 wrote:



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 encountered
ORA-00904: invalid column name
EXP-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). ===== 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).