Home » RDBMS Server » Server Administration » EXP-00008: ORACLE error 21779 encountered
EXP-00008: ORACLE error 21779 encountered [message #62200] Mon, 05 July 2004 05:18 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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.
Previous Topic: Oracle8i doesn't start automatically on Windows XP
Next Topic: control users
Goto Forum:
  


Current Time: Thu Mar 28 06:17:45 CDT 2024