Members   Search   Help    Register    Login   Home
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: 18
Registered: June 2009
Location: india
Junior 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)
Report message to a moderator
Re: export error [message #408056 is a reply to message #408055] Sat, 13 June 2009 07:48 Go to previous message
Mahesh Rajendran
Messages: 9777
Registered: March 2002
Location: oracleDocoVille
Senior Member
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.
Report message to a moderator
Previous Topic:How i can prevent backup for specific IP Address
Next Topic:oracle_datapump error (merged)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 22:15:29 CST 2009

Total time taken to generate the page: 0.20923 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.