Hi,
I appled 8.1.6.3 patch few days back. To my surprise, another instance did not have the same problem after applying the same patch.
I got another reply to run $ORACLE_HOME/javavm/install/initdbj.sql as internal user and it worked like a magic!! I am still trying to relate the javavm and export utility !
Thanks to all who replied.
Now,I got to close that tar opened with Metalink which is in "work in progress" mode for sometime!
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 11:05:42 -0800
>
>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:
>
>
>
>style='background-color:'>
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
>
"-//W3C//DTD HTML 4.0 Transitional//EN">
>
>
>
>
>
>
>
>
>
>
>
>
>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 >href='http://go.msn.com/bql/hmtag_itl_EN.asp'>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).
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 Wed Aug 08 2001 - 16:50:46 CDT
