| EXP-00008: ORACLE error 21779 encountered [message #62200] |
Mon, 05 July 2004 05:18  |
Rajesh Lad
Messages: 5
Registered: June 2004
|
Junior Member |
|
|
While exporting on a win2k server with oracle failsafe on oracle 9.2.0.4 I am gatting this error pl. can Help
D:>exp
Export: Release 9.2.0.4.0 - Production on Mon Jul 5 17:53:11 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: nds
Password:
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
Enter array fetch buffer size: 4096 >
Export file: EXPDAT.DMP > full.dmp
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > e
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
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
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 21779 encountered
ORA-21779: duration not active
ORA-06512: at "SYS.DBMS_AW", line 106
ORA-06512: at "SYS.DBMS_AW", line 222
ORA-06512: at "SYS.DBMS_AW_EXP", line 264
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_inf
o_exp
. exporting cluster definitions
EXP-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TR
ANSFORM_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-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TR
ANSFORM_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
Regards
Rajesh
|
|
|
|
| Re: EXP-00008: ORACLE error 21779 encountered [message #62223 is a reply to message #62200] |
Tue, 06 July 2004 03:33  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Was the DB patched up to 9.2.0.4?
if so,
-- do a clean shutdown.
-- login as sys
-- issue
sql> startup migrate;
-- run the cathpatch.sql
sql> $ORACLE_HOME/rdbms/admin/catpatch.sql
-- do a clean shutdown
-- startup normal
-- try export again
ELSE
if you are not using the optional schemas in ur DB ( XMLDB, data mining etc) remove them cleanly and try again.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
