Home » RDBMS Server » Server Utilities » Full DB Export Hang
Full DB Export Hang [message #204768] Wed, 22 November 2006 01:05 Go to next message
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 #204775 is a reply to message #204768] Wed, 22 November 2006 01:39 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi Mohd,

1. Import ur operation through 'SYSTEM' user.
2. Run utlrp.sql


Hope this helps
Taj.
Re: Full DB Export Hang [message #226326 is a reply to message #204775] Fri, 23 March 2007 04:48 Go to previous message
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
Previous Topic: DATAPUMP example, appending rows to existing table (parent-child relation)
Next Topic: SQL*LOADER - Inserting values in wrong column
Goto Forum:
  


Current Time: Mon Dec 05 21:16:09 CST 2016

Total time taken to generate the page: 0.10392 seconds