ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier [message #184925] |
Fri, 28 July 2006 13:32 |
abollinger123
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 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Enter array fetch buffer size: 4096 > 4096
Export file: EXPDAT.DMP > niku.7.5.2.3435.fp02.07272006.dmp
(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,
allen
[Updated on: Fri, 28 July 2006 13:48] Report message to a moderator
|
|
|