Full database export hangs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Full database export hangs

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Full database export hangs

    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?

  2. #2
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    I am not sure what is that for, but I am sure Oracle does not support exports when connected as SYS.
    Please try with SYSTEM

  3. #3
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    Yep
    faced the same type of error whille doing full export with sys.System has to be used.
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width