RE: ORA-00904 - RESOLVED!

Hi, Joe,

The ORA-00904 is resolved. I think the 'ALTER SYSTEM FLUSH SHARED_POOL' solved the problem.

Thanks for the reply.

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