Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    17

    Question Unanswered: Oracle Export failed

    I am trying to do an export on oracle 8i running on windows NT

    This is what I am doing
    exp SYSTEM/password FULL=y FILE=I:\data_exp\dba.dmp GRANTS=y ROWS=y log=I:\data_exp\exp_log.log

    I don't think that's important but I: is a network drive.

    So I am getting the following errors - this is the end of the log file.

    . exporting referential integrity constraints
    . exporting synonyms
    . exporting views
    . exporting stored procedures
    . exporting operators
    . exporting indextypes
    . exporting bitmap, functional and extensible indexes
    . exporting posttables actions
    EXP-00008: ORACLE error 4068 encountered
    ORA-04068: existing state of packages has been discarded
    ORA-04063: has errors
    ORA-04063: package body "SYS.DBMS_AQ_IMPORT_INTERNAL" has errors
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at line 1
    ORA-06512: at "SYS.DBMS_SYS_SQL", line 1076
    ORA-06512: at "SYS.DBMS_SQL", line 316
    ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 84
    ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 135
    ORA-06512: at line 1
    EXP-00000: Export terminated unsuccessfully

    Can anyone help?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    1) Connect as sys
    2) Run owmcpkgb.plb to recreate SYS.LT_EXPORT_PKG package body
    3) Rerun catexp.sql
    4) Rerun catproc.sql
    5) Try the export again.
    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.

  3. #3
    Join Date
    Mar 2004
    Posts
    17
    You are saying that I should
    3) Rerun catexp.sql
    4) Rerun catproc.sql

    Does that mean that I had to run them before performing the export, beacuse I didn't. I just ran the exp...

    Originally posted by anacedent
    1) Connect as sys
    2) Run owmcpkgb.plb to recreate SYS.LT_EXPORT_PKG package body
    3) Rerun catexp.sql
    4) Rerun catproc.sql
    5) Try the export again.

  4. #4
    Join Date
    Mar 2004
    Posts
    17
    Another thing - where do I run owmcpkgb.plb from. Is it from sqlplus? or just from the dos prompt

    Thank you for your help

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >You are saying that I should
    >3) Rerun catexp.sql
    >4) Rerun catproc.sql
    They "should" have been run when the DB was created.
    They "should" fix whatever is broken or missing now.

    >Where do I run owmcpkgb.plb from. Is it from sqlplus?
    Yes, from SQL*Plus

    All need to be run as SYS!

    All of this is like giving Chicken Soup (TM) to a dead man.
    It can't hurt anything & just might help him.
    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
  •