Home » Developer & Programmer » JDeveloper, Java & XML » ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier
ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier [message #184925] Fri, 28 July 2006 13:32
Messages: 14
Registered: January 2006
Location: NC
Junior Member
Hi everyone,
I am trying to export a 9i database. However, no matter if I try and export a specific user, or the entire db, I keep receiving this error. ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier. I have searched around and found some references which point to possible solutions on Metalink (of which I am not a member). Any, and I mean any thoughts from someone who frequents this forum? The entire error appears as follows:

Connected to: Oracle9i Enterprise Edition Release - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release - Production
Enter array fetch buffer size: 4096 > 4096

Export file: EXPDAT.DMP > niku.

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 2

Export grants (yes/no): yes > yes

Export table data (yes/no): yes > yes

Compress extents (yes/no): yes > yes

Export done in UTF8 character set and UTF8 NCHAR character set

About to export specified users ...
User to be exported: (RETURN to quit) > niku

User to be exported: (RETURN to quit) >

. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user NIKU
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier
EXP-00000: Export terminated unsuccessfully

**Update: is it possible I am trying to export a db that contains values for a different language code, such as Chinese. It is entirely possible this db contains records of a different language character set. Just an additional thought.

Thank you in advance,

[Updated on: Fri, 28 July 2006 13:48]

Report message to a moderator

Previous Topic: Restrict DBMS_METADATA.GET_XML output
Next Topic: xml parsing failed,, xdk is installed
Goto Forum:

Current Time: Mon Oct 24 00:21:42 CDT 2016

Total time taken to generate the page: 0.12106 seconds