| Full DB Export Hang [message #204768] |
Wed, 22 November 2006 01:05  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
Dear All,
I am trying to take a full backup using the following but it failed with the following errors
C:\>exp 'sys/gateway@raiwind as sysdba' file=c:\full_raiwind.dmp full=y log=c:\log1.log
Export: Release 8.1.7.0.0 - Production on Wed Nov 22 09:54:54 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
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 object type definitions
EXP-00090: cannot pin type "OE"."CATEGORY_TYP"
EXP-00056: ORACLE error 22303 encountered
OCI-22303: type "OE"."CATEGORY_TYP" not found
EXP-00090: cannot pin type "OE"."LEAF_CATEGORY_TYP"
EXP-00056: ORACLE error 22303 encountered
OCI-22303: type "OE"."LEAF_CATEGORY_TYP" not found
EXP-00090: cannot pin type "OE"."COMPOSITE_CATEGORY_TYP"
EXP-00056: ORACLE error 22303 encountered
OCI-22303: type "OE"."COMPOSITE_CATEGORY_TYP" not found
EXP-00090: cannot pin type "OE"."CATALOG_TYP"
EXP-00056: ORACLE error 22303 encountered
OCI-22303: type "OE"."CATALOG_TYP" not found
Can anybody guide me in this regard?
|
|
|
|
|
|
| Re: Full DB Export Hang [message #226326 is a reply to message #204775] |
Fri, 23 March 2007 04:48  |
b_kareem@sify.com
Messages: 5
Registered: March 2007
Location: india
|
Junior Member |
|
|
If your using windows 2003 dont install service pack 1 in it.If you have install the service pack 1 then uninstall it and then try to export the data.
Or
exp 'system/gateway@raiwind as sysdba' file=c:\full_raiwind.dmp owner='give the schema name' log=c:\log1.log
Or
exp 'system/gateway@raiwind as sysdba' file=c:\full_raiwind.dmp full=y log=c:\log1.log
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
