export error on 8.1.5

[hannah00]

I know I know, it desupport version and my client still want to be on this version so it's their choice. I got an error on the export as follow:


The following is being seen when exporting from Oracle 8.1.x

. exporting referential integrity constraints
. exporting synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully

I did some research on metalink and seems like Java related issue. the question is "how can we check the database to see if Java is enabled????

thanks,

[bazza]

For pre 9i databases, couple of tests:

SQL> select count(object_name) from all_objects where object_type like 'JAVA%' and status='VALID';

Will return 0 if java not enabled.

Also if java is enabled you should be able to:

SQL> desc dbms_java

Post 9i, a simple select against the dba_registry view is enough.

Bazza