Re: ORA-00904

I dont necessarily recommend it but thats whats in most release notes for patches sets, so I tend to follow the instructions oracle gives in most cases :)

Joe
"PHU,JULIA (HP-Sunnyvale,ex2)" wrote:
>
> Hi, Joe,
>
> 'an upgrade or patch and then forget to run catalog, catproc,
> catrep(if ur using replication), utlirp.'
>
> Do you recommend to run catalog, catproc, catrep, and utlirp?
>
> I looked up a doc in Metalink and couldn't resolve my problem. Perhaps I
> looked up the incorrect one. Please send me info if you will.
>
> Thank you.
> Julia
>
> -----Original Message-----
> Sent: Saturday, May 26, 2001 6:00 AM
> To: Multiple recipients of list ORACLE-L
>
> dealt with that one this week on aix platform.
>
> a couple of things can cause it.
>
> 1. an upgrade or patch and then forget to run catalog, catproc,
> catrep(if ur using replication), utlirp.
>
> 2. using a version of export that is not compatible with the
> database(no one flame me for this, it was on metalink).
>
> if you want moer into on the error, let me know, i'll go and get the doc
> id from metalink so you can look it up.
>
> joe
>
> "PHU,JULIA (HP-Sunnyvale,ex2)" wrote:
> >
> > Greetings,
> >
> > I'm lost on the 'ORA-00904: invalid column name' error message. Can
> someone
> > shed some light on it? It is 8i on NT box with sp6a.
> >
> > Regards,
> > Julia Phu
> >
>
> --
> Joe Testa http://www.oracle-dba.com
> Performing Remote DBA Services, need some backup DBA support?
> For Sale: Oracle-dba.com domain, its not going cheap but feel free to
> ask:)
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joseph S. Testa
> INET: oracle-l_at_the-testas.net
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: PHU,JULIA (HP-Sunnyvale,ex2)
> INET: julia_phu_at_hp.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)

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: oracle-l_at_the-testas.net

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