Full DB Export Session Hanged [message #288334] |
Mon, 17 December 2007 02:18 |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
Dear All,
I am trying to export full db with the following script
C:\>EXP USERID=SYSTEM/**** FILE=D:\oracle\backup\dump\recent_most.dmp direct=y full=y log=D:\oracle\backup\dump\recent_most.log
Export: Release 9.2.0.6.0 - Production on Mon Dec 17 13:07:55 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.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
The export session got hanged for 4-5 hrs at
exporting object type definitions
what could be the reasons ?
please suggest!
[EDITED by LF: removed SYSTEM password]
[Updated on: Mon, 17 December 2007 04:10] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|
Re: Full DB Export Session Hanged [message #288388 is a reply to message #288334] |
Mon, 17 December 2007 05:39 |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
i traced the export session and found the session is being held while exporting object type definitions
and i got the following
ALTER TYPE "OE"."ORDER_TYP" COMPILE SPECIFICATION REUSE SETTINGS
and after a long time the session is terminated with the following
EXP-00090: cannot pin type "OE"."CUSTOMER_TYP"
EXP-00056: ORACLE error 22303 encountered
OCI-22303: type "OE"."CUSTOMER_TYP" not found
EXP-00056: ORACLE error 24323 encountered
ORA-24323: value not allowed
EXP-00000: Export terminated unsuccessfully
|
|
|
|
|
|
Re: Full DB Export Session Hanged [message #288530 is a reply to message #288397] |
Mon, 17 December 2007 23:25 |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
I have lots of schemas in my DB so i can't export schemas individualy
In my last post i said that the problem is resoloved but infact the problem is not resolved
At almost end of export i got the following
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. 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
I already tried catexp.sql,catalog.sql,catproc.sql and utlrp.sql
but the problem is still there
please suggest!
|
|
|
|
|