OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » export error (oracle 8.1.7,aix 4,)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

export error [message #408055]

Sat, 13 June 2009 07:13

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)

Report message to a moderator

Re: export error [message #408056 is a reply to message #408055]

Sat, 13 June 2009 07:48

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Previous Topic:	How i can prevent backup for specific IP Address
Next Topic:	oracle_datapump error (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 06:02:45 CDT 2024