Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2008

    Unanswered: 10g_export_errors

    Hi DBAs,

    I'm trying to export a schema from my 10g RAC database, but i'm getting a whole lot of errors. Infact, the same script i used to export the same schema from a 9i database successfully is what i'm using, as shown below:

    > exp system/xxxxxx@labtest1 file=/u02/epiphany_sys.dmp owner=epiphany_sys_meta_data log=/u02/epiphany_sys.log statistics=none buffer=80000 consistent=y

    The errors i'm getting are:

    Connected to: Oracle Database 10g Enterprise Edition Release - 64bit Production
    With the Partitioning, Real Application Clusters, OLAP and Data Mining options
    Export done in US7ASCII character set and UTF8 NCHAR character set
    server uses AL32UTF8 character set (possible charset conversion)

    About to export specified users ...
    . exporting pre-schema procedural objects and actions
    EXP-00008: ORACLE error 4067 encountered
    ORA-04067: not executed, package body "SYS.LT_EXPORT_PKG" does not exist
    ORA-06508: PL/SQL: could not find program unit being called: "SYS.LT_EXPORT_PKG"
    ORA-06512: at line 1
    EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
    EXP-00008: ORACLE error 6550 encountered
    ORA-06550: line 1, column 13:
    PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored
    EXP-00083: The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp
    . exporting foreign function library names for user EPIPHANY_SYS_META_DATA
    . exporting PUBLIC type synonyms
    . exporting private type synonyms
    . exporting object type definitions for user EPIPHANY_SYS_META_DATA
    About to export EPIPHANY_SYS_META_DATA's objects ...
    . exporting database links
    . exporting sequence numbers
    . exporting cluster definitions
    EXP-00056: ORACLE error 932 encountered
    ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
    EXP-00000: Export terminated unsuccessfully

    Does anyone have an idea of what's going on? Your help will be highly appreciated.



  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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