DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Am getting following Errors during importing data

  1. #1
    Join Date
    Jul 2012
    Posts
    14

    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','ARTCOCA');
    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','RESDGENE');
    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','RESOBJ');
    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
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You are importing text based indexes into a schema that does not have the right privileges to create text based indexes. You need to grant that right when you create the user that you import into. At this point do the grant and you should be able to import only the indexes rather than re-import everything. although if you have the ddl for the missing indexes you might try that since you should rebuild all of the indexes anyway.

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