Import errors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Import errors

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    155

    URGENT - Import Errors

    Please look at the below error messages (while importing) and
    let me know if I need to re-build the catalog or......



    #####################################

    Import: Release 8.1.5.0.0 - Production on Thu Jan 25
    17:10:41 2001

    (c) Copyright 1999 Oracle Corporation. All rights
    reserved.


    Connected to: Oracle8i Enterprise Edition Release
    8.1.5.0.0 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 - Production


    Export file created by EXPORT:V08.01.05 via
    conventional path
    import done in WE8ISO8859P1 character set and
    WE8ISO8859P1 NCHAR character set
    export client uses US7ASCII character set (possible
    charset conversion)
    IMP-00017: following statement failed with ORACLE
    error 4068:
    "BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;"
    IMP-00003: ORACLE error 4068 encountered
    ORA-04068: existing state of packages has been
    discarded
    ORA-04067: not executed, package body
    "SYS.DBMS_REPCAT_UTL" does not exist
    ORA-06508: PL/SQL: could not find program unit being
    called
    ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 94
    ORA-06512: at line 1
    IMP-00000: Import terminated unsuccessfully

    #####################################

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Might be good idea and good habbit too if you are going from version to version (8.0 to 8.1). Not a big deal if its between releases. (8.1.x to 8.1.x) Seems Charecter set also diffrent though its superset.

    [Edited by sreddy on 01-25-2001 at 04:03 PM]

  3. #3
    Join Date
    Sep 2000
    Posts
    155

    Can someone help me re-create Data Dictionary/Catalog???

    Running the following as SYS would be enough???

    $ORACLE_HOME/rdbms/admin/catalog.sql
    $ORACLE_HOME/rdbms/admin/catexp.sql
    $ORACLE_HOME/rdbms/admin/catproc.sql

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    catalog.sql and catproc.sql would do.
    Catalog.sql includes catexp.sql.
    you can see that at the end of catalog.sql.

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