Re: Weird -904 Problem

From: Christian Trassens <ctrassens_at_yahoo.com>
Date: Tue, 07 Aug 2001 10:54:17 -0700
Message-ID: <F001.00363184.20010807110542@fatcity.com>

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 <jnair75_at_hotmail.com> 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
<CTRASSENS_at_YAHOO.COM>
<DIV></DIV>>Reply-To: ORACLE-L_at_fatcity.com
<DIV></DIV>>To: Multiple recipients of list
ORACLE-L <ORACLE-L_at_FATCITY.COM>
<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"
<WCARLE_at_ATT.COM>
<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>> > wcarle_at_att.com
<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: wcarle_at_att.com
<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: ListGuru_at_fatcity.com (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>>ctrassens_at_yahoo.com
<DIV></DIV>>ctrassens_at_hotmail.com
<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>&gt;-- 

<DIV></DIV>&gt;Author: Christian Trassens 

<DIV></DIV>&gt; INET: ctrassens_at_yahoo.com

<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: ListGuru_at_fatcity.com (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: jnair75_at_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_at_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_at_yahoo.com
ctrassens_at_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_at_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_at_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 - 12:54:17 CDT