| Error while exporting [message #175820] |
Mon, 05 June 2006 09:51  |
kmsalih
Messages: 197
Registered: March 2006
|
Senior Member |
|
|
hi,
Exp userid=scott/tiger@orcl file=scott.dmp owner=scott log=scott.log
I got EXP-00024 error and i execute catexp.sql script and ths issue was solved.
After that i issued the same command and i got the floowing error.
. 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
Please guide me.
Regards
Salih KM
|
|
|
|
|
|
|
|
| Re: Error while exporting [message #175823 is a reply to message #175822] |
Mon, 05 June 2006 10:09  |
kmsalih
Messages: 197
Registered: March 2006
|
Senior Member |
|
|
thanks a lot to ebrian and mahesh.
it is solved by running catmeta.sql
but still one more error.
tables are exported.
. exporting triggers
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 26:
PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 26:
PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored
EXP-00000: Export terminated unsuccessfully
Regards
Salih KM
[Updated on: Mon, 05 June 2006 10:11] Report message to a moderator |
|
|
|
| Re: Error while exporting [message #176020 is a reply to message #175823] |
Tue, 06 June 2006 07:16 |
kmsalih
Messages: 197
Registered: March 2006
|
Senior Member |
|
|
hi all,
issue was solved by recreating the XDB user.
Dropped XDB user by running catnoqm script and create a new XDB user by running catqm.sql script
Regards
Salih KM
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
