Home » RDBMS Server » Server Utilities » export error (oracle 8.1.7,aix 4,)
export error [message #408055] Sat, 13 June 2009 07:13 Go to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member


Hi all,


when i take export of oracle 9.2.0.1.0 database which is on windows server from ibm aix server 4.3 which has oracle 8.1.7 i am getting the below error.please any one has idea about that .quick reply will higly appreciated.thanks a lot.


exp system/manager@maximo file=full.dmp log=fulllog.log full=y

Export: Release 8.1.7.0.0 - Production on Sat Jun 13 16:09:58 2009

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in AR8ISO8859P6 character set and UTF8 NCHAR character set
server uses AR8MSWIN1256 character set (possible charset conversion)

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 foundSegmentation fault(coredump)
Re: export error [message #408056 is a reply to message #408055] Sat, 13 June 2009 07:48 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
OE is just a sample schema and I would not worry about it (unless you happen to use it for production purpose).
To make it simple, just export the schema's you want.
Check metalink. These errors usually caused by invalid objects.
Previous Topic: How i can prevent backup for specific IP Address
Next Topic: oracle_datapump error (merged)
Goto Forum:
  


Current Time: Fri Dec 09 02:09:35 CST 2016

Total time taken to generate the page: 0.08477 seconds