Re: Weird -904 Problem

Wed, 08 Aug 2001 14:50:46 -0700

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 <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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 <[EMAIL PROTECTED]>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

>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

>




 

>"-//W3C//DTD HTML 4.0 Transitional//EN">
>
>
>
>
>
>
>
>
 
>
>
>
>
>From: Christian Trassens
><[EMAIL PROTECTED]>
>
>Reply-To: [EMAIL PROTECTED]
>
>To: Multiple recipients of list
>ORACLE-L <[EMAIL PROTECTED]>
>
>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"
><[EMAIL PROTECTED]>
>
>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
>
> > [EMAIL PROTECTED]
>
> >
>
> > --
>
> > Please see the official ORACLE-L
>FAQ:
>
> > http://www.orafaq.com
>
> > --
>
> > Author: Carle, William T (Bill),
>NLCIO
>
> > 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).
>

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: [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).

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: [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).

Reply via email to