import failing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: import failing

  1. #1
    Join Date
    Mar 2000
    Location
    woodbridge,nj,USA
    Posts
    14
    DBA's

    I get the following error when I try to do an import.

    I reran catexp.sql and utlrp.sql as sys however I still get
    the same error.

    Any help appreciated.
    Thanks
    -u-

    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-04063: package body "SYS.DBMS_REPCAT_MIG_INTERNAL" has errors
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 95
    ORA-06512: at line 1
    IMP-00000: Import terminated unsuccessfully

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131

    Question

    Did you set ..
    IGNORE=Y

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    This is a known isue (bug?) in some 8i releases. Check note 203317.1 on Metalink.

    If you don't have access to Metalink, do the following:

    Connect as SYS using svrmgrl (don't use SQL*Plus!!!) and rerun the following scripts:

    1)catrepr.sql (Removes Replication related objects)

    2)catrep.sql (Creates Replication related objects)

    3)utlrp.sql (Recompile Invalid PL/SQL modules).

    The basic reason for this problem is the fact that during the database creation some replication packages (that are also used by the IMPort) were created incomplete and invalid, and they can't be recompiled. And the culprit of the problem is the SQL*Plus, in which those scripts were run during instalation (just like suggested by the manuals), but its deffault buffer was too small for the creation of those packages. Using svrmgrl when creating them avoids those problems.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    if you run cartepr you will also have to rerun catproc as well, cartepr whacks some objects created by catproc.

    steve
    I'm stmontgo and I approve of this message

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