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>
<html><div
style='background-color:'><P><BR><BR>Hi,</P>
<P>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. </P>
<P>I get the following error:</P>
<P>EXP-00008: ORACLE error 904
encountered<BR>ORA-00904: invalid column
name<BR>EXP-00000: Export terminated
unsuccessfully.</P>
<P>No idea why this happened?I am not sure if this is
connected to the 904 mentioned here.</P>
<P>Rgds,</P>
<P>Jyoti</P>
<P><BR><BR><BR> </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>
<DIV> </DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: Christian Trassens
<[EMAIL PROTECTED]>
<DIV></DIV>>Reply-To: [EMAIL PROTECTED]
<DIV></DIV>>To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<DIV></DIV>>Subject: Re: Weird -904 Problem
<DIV></DIV>>Date: Tue, 07 Aug 2001 06:06:26 -0800
<DIV></DIV>>
<DIV></DIV>>Do you create the table with any
strange symbol or in
<DIV></DIV>>lowercase or mixing lower and upper or
within
<DIV></DIV>>spaces......?, As f.e.:
<DIV></DIV>>
<DIV></DIV>>create table weird ( "Weird Field"
NUMBER );
<DIV></DIV>>
<DIV></DIV>>Regards.
<DIV></DIV>>
<DIV></DIV>>--- "Carle, William T (Bill), NLCIO"
<[EMAIL PROTECTED]>
<DIV></DIV>>wrote:
<DIV></DIV>> > Howdy,
<DIV></DIV>> >
<DIV></DIV>> > I had an interesting situation
today. The
<DIV></DIV>> > application was trying to
<DIV></DIV>> > insert rows into a table and was
getting a -904
<DIV></DIV>> > error for invalid column.
<DIV></DIV>> > The actual problem was that the
tablespace
<DIV></DIV>> > containing the indexes was full
<DIV></DIV>> > and the index was unable to
extend. That was in the
<DIV></DIV>> > alert log. However, when
<DIV></DIV>> > doing a tkprof on their sql
statements, it showed
<DIV></DIV>> > every sql statement
<DIV></DIV>> > getting a -904. It doesn't seem
like it should do
<DIV></DIV>> > that. Has anyone seen this
<DIV></DIV>> > before?
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> > Bill Carle
<DIV></DIV>> > AT&T
<DIV></DIV>> > Database Administrator
<DIV></DIV>> > 816-995-3922
<DIV></DIV>> > [EMAIL PROTECTED]
<DIV></DIV>> >
<DIV></DIV>> > --
<DIV></DIV>> > Please see the official ORACLE-L
FAQ:
<DIV></DIV>> > http://www.orafaq.com
<DIV></DIV>> > --
<DIV></DIV>> > Author: Carle, William T (Bill),
NLCIO
<DIV></DIV>> > INET: [EMAIL PROTECTED]
<DIV></DIV>> >
<DIV></DIV>> > Fat City Network Services --
(858) 538-5051 FAX:
<DIV></DIV>> > (858) 538-5051
<DIV></DIV>> > San Diego, California -- Public
Internet
<DIV></DIV>> > access / Mailing Lists
<DIV></DIV>> >
<DIV></DIV>>--------------------------------------------------------------------
<DIV></DIV>> > To REMOVE yourself from this
mailing list, send an
<DIV></DIV>> > E-Mail message
<DIV></DIV>> > to: [EMAIL PROTECTED] (note
EXACT spelling of
<DIV></DIV>> > 'ListGuru') and in
<DIV></DIV>> > the message BODY, include a line
containing: UNSUB
<DIV></DIV>> > ORACLE-L
<DIV></DIV>> > (or the name of mailing list you
want to be removed
<DIV></DIV>> > from). You may
<DIV></DIV>> > also send the HELP command for
other information
<DIV></DIV>> > (like subscribing).
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>=====
<DIV></DIV>>Eng. Christian Trassens
<DIV></DIV>>Senior DBA
<DIV></DIV>>Systems Engineer
<DIV></DIV>>[EMAIL PROTECTED]
<DIV></DIV>>[EMAIL PROTECTED]
<DIV></DIV>>Phone : 541149816062
<DIV></DIV>>
<DIV></DIV>>__________________________________________________
<DIV></DIV>>Do You Yahoo!?
<DIV></DIV>>Make international calls for as low as
$.04/minute with Yahoo! Messenger
<DIV></DIV>>http://phonecard.yahoo.com/
<DIV></DIV>>--
<DIV></DIV>>Please see the official ORACLE-L FAQ:
http://www.orafaq.com
<DIV></DIV>>--
<DIV></DIV>>Author: Christian Trassens
<DIV></DIV>> INET: [EMAIL PROTECTED]
<DIV></DIV>>
<DIV></DIV>>Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051
<DIV></DIV>>San Diego, California -- Public
Internet access / Mailing Lists
<DIV></DIV>>--------------------------------------------------------------------
<DIV></DIV>>To REMOVE yourself from this mailing
list, send an E-Mail message
<DIV></DIV>>to: [EMAIL PROTECTED] (note EXACT
spelling of 'ListGuru') and in
<DIV></DIV>>the message BODY, include a line
containing: UNSUB ORACLE-L
<DIV></DIV>>(or the name of mailing list you want
to be removed from). You may
<DIV></DIV>>also send the HELP command for other
information (like subscribing).
<DIV></DIV></div><br clear=all><hr>Get your FREE
download of MSN Explorer at <a
href='http://go.msn.com/bql/hmtag_itl_EN.asp'>http://explorer.msn.com</a><br></html>
--
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).
=====
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).
