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