Home » RDBMS Server » Server Administration » ORA-00904: invalid column name
ORA-00904: invalid column name [message #54205] Mon, 04 November 2002 22:20 Go to next message
Jeolieos
Messages: 5
Registered: October 2002
Junior Member
Oh,my god!How can I export my db!
After drop and rebuild the JVM,ORA-06553 has gone.
But ORA-00904 comes.
Pls help me once more!
Log:
. . exporting table ... .. .. exported
. . exporting table PAGE_INFO 0 rows exported
. exporting synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully

Thanks!
ORA-00904: invalid column name sp1 [message #54211 is a reply to message #54205] Tue, 05 November 2002 03:44 Go to previous messageGo to next message
Jeolieos
Messages: 5
Registered: October 2002
Junior Member
Yes.if I run jvmrm.sql,error code changes to ORA-00904
Re: ORA-00904: invalid column name [message #54214 is a reply to message #54205] Tue, 05 November 2002 06:00 Go to previous messageGo to next message
Dilip.
Messages: 1
Registered: November 2002
Junior Member
Run Catexp.sql logged in as SYS. Should help.
Re: ORA-00904: invalid column name [message #54244 is a reply to message #54205] Wed, 06 November 2002 11:53 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
There is a known issue with the removal of JVM in version 8.1.6. It doesn't completely remove it. If you are using 8.1.6 do this:

To run the script correctly, you will need to edit the RMJVM.SQL script and change line

"call rmjvm.run(true)" to "execute rmjvm.run(true)".

On Oracle8i 8.1.6 for Windows NT, the file rmjvm.sql does NOT exists! Create the file rmjvm.sql containing the following:

set serveroutput on
variable jvmrmaction varchar2(30) execute :jvmrmaction := 'FULL_REMOVAL';
@@jvmrm
execute rmjvm.run(true);
Previous Topic: Urgent! Where to download oracle 8.0.6?
Next Topic: Adding maxdatafiles
Goto Forum:
  


Current Time: Thu Sep 19 16:53:06 CDT 2024