Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    13

    Unanswered: Am getting following Errors during importing data

    Hi All,

    I am getting following errors while importing data.

    SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
    ORA-39083: Object type INDEX failed to create with error:
    ORA-06550: line 2, column 1:
    PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
    ORA-06550: line 2, column 1:
    PL/SQL: Statement ignored
    ORA-06550: line 8, column 1:
    PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
    ORA-06550: line 8, column 1:
    PL/SQL: Statement ignored
    ORA-06550: line 10, column 1:
    PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
    ORA-06550: line 10, column 1:
    PL/SQL: Statement ignored
    ORA-06550: line 12, column 1:
    PLS
    ORA-39083: Object type INDEX failed to create with error:
    ORA-06550: line 2, column 1:
    PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
    ORA-06550: line 2, column 1:
    PL/SQL: Statement ignored
    ORA-06550: line 8, column 1:
    PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
    ORA-06550: line 8, column 1:
    PL/SQL: Statement ignored
    ORA-06550: line 10, column 1:
    PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
    ORA-06550: line 10, column 1:
    PL/SQL: Statement ignored
    ORA-06550: line 12, column 1:
    PLS
    ORA-39083: Object type INDEX failed to create with error:
    ORA-06550: line 2, column 1:
    PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
    ORA-06550: line 2, column 1:
    PL/SQL: Statement ignored
    ORA-06550: line 8, column 1:
    PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
    ORA-06550: line 8, column 1:
    PL/SQL: Statement ignored
    ORA-06550: line 10, column 1:
    PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
    ORA-06550: line 10, column 1:
    PL/SQL: Statement ignored
    ORA-06550: line 12, column 1:
    PLS
    Processing object type SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION
    ORA-39083: Object type POST_TABLE_ACTION failed to create with error:
    ORA-01435: user does not exist
    Failing sql is:
    BEGIN
    SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('C509MHA','ARTCO CA');
    END;
    ORA-39083: Object type POST_TABLE_ACTION failed to create with error:
    ORA-01435: user does not exist
    Failing sql is:
    BEGIN
    SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('C509MHA','RESDG ENE');
    END;
    ORA-39083: Object type POST_TABLE_ACTION failed to create with error:
    ORA-01435: user does not exist
    Failing sql is:
    BEGIN
    SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('C509MHA','RESOB J');
    END;
    Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
    Processing object type SCHEMA_EXPORT/TABLE/MATERIALIZED_VIEW_LOG
    Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 9 error(s) at 14:48:41


    Can anyone please suggest me why am getting these errors and what is the solution. These errors can ignorable ?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    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
  •