| Export error [message #73751] |
Wed, 30 June 2004 20:12  |
Rajesh Lad
Messages: 5
Registered: June 2004
|
Junior Member |
|
|
When i am trying to export from 9.2.0.4 oracle 9i & os windows 2000 Fowalling erroe ocured
EXP nds/nds@PDONDS FILE=D:backupnds290604y.DMP FULL =
Y
Export: Release 9.2.0.4.0 - Production on Tue Jun 29 13:27:44 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
Regards Rajesh
|
|
|
|
|
|
| Re: Export error [message #73778 is a reply to message #73755] |
Mon, 12 July 2004 08:47  |
kyle wagner
Messages: 3
Registered: July 2004
|
Junior Member |
|
|
I had the same error in 9i (9.2.0.5) running under windows 2k pro, and I have run catexp.sql as sys (sysdba). I then bumped my db. Now I'm getting this error:
Export: Release 9.2.0.5.0 - Production on Mon Jul 12 09:46:12 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user MyDbUser. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user MyDbUser
About to export MyDatabase's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3926
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4050
ORA-06512: at "SYS.DBMS_METADATA", line 836
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
Any ideas about what went wrong? I got no errors when running catexp.sql. I have never had problems before when exporting, but it seems like patching to 9.2.0.5 might have given me a problem.
thanks,
kyle
|
|
|
|
| Re: Export error [message #73780 is a reply to message #73778] |
Mon, 12 July 2004 09:34 |
kyle wagner
Messages: 3
Registered: July 2004
|
Junior Member |
|
|
I have gotten rid of the error by running (SYS as SYSDBA)
@(ORA_HOME)/rdbms/admin/catalog.sql
@(ORA_HOME)/rdbms/admin/catproc.sql
After this, I've been able to export without errors.
Not sure why I have to do this. If anyone knows why a newly-created database would require these scripts, I'd appreciate knowing the reason. Seems to only happen after I've patched from 9.2.0.1 to 9.2.0.5 and then created a new database, running catpatch.sql & utlrp.sql on it.
kyle
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
