Full export error
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Full export error

  1. #1
    Join Date
    Feb 2002
    Posts
    41

    Unhappy Full export error

    Hi fellows, I'm getting the following error while issuing a full export, is there a way to solve this?

    ------
    . exporting referential integrity constraints
    . exporting posttables actions
    EXP-00008: ORACLE error 2083 encountered
    ORA-02083: database name has illegal character '.'
    ORA-06512: at "SYS.DBMS_UTILITY", line 78
    ORA-06512: at "SYS.DBMS_UTILITY", line 107
    ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 552
    ORA-06512: at line 1
    ORA-06512: at "SYS.DBMS_SYS_SQL", line 787
    ORA-06512: at "SYS.DBMS_SQL", line 328
    ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 82
    ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 133
    ORA-06512: at line 1
    EXP-00000: Export terminated unsuccessfully
    -------

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333

  3. #3
    Join Date
    Feb 2002
    Posts
    41
    I wish I had a metalink user, but then again I don't.

    Any other suggestion?

  4. #4
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    what version? what OS?
    -- Dilip

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    Problem Explanation:
    ====================
    This can be caused by running the script 'catnoqueue.sql' without first dropping all the queue tables in the database. See [BUG:647800] which is fixed in 8.0.6.

    Problem References:
    ===================
    [BUG:647800]
    Solution Explanation
    ====================
    The script 'catnoqueue.sql' has been run which drops the tables DEF$AQCALL and DEF$AQERROR. The corresponding rows in SYS.EXPACT$ are not dropped. Prior to running 'catnoqueue.sql', check for and drop any existing queue tables. To ascertain the existence of any queue tables, from SQL*Plus issue the following command to list all queue tables:

    SELECT * FROM dba_queue_tables

    To drop the queue tables, from SQL*Plus issue the following command:

    execute dbms_aqadm.drop_queue_table('')

    Solution Description:
    =====================
    If 'catnoqueue.sql' has already been run, then you need to delete from SYS.EXPACT$ rows for non-existent queue tables. The following steps will allow a full export to run successfully: All rows from the SYS.EXPACT$ table for the function package DBMS_AQ_IMPORT_INTERNAL need to be deleted.

    1. Login into Server Manager as INTERNAL or SYS; or, login into SQL*Plus as SYS

    2. Enter the following SQL command:
    DELETE FROM SYS.EXPACT$
    WHERE FUNC_PACKAGE = 'DBMS_AQ_IMPORT_INTERNAL';

    After the statement issue a 'commit' so the statement can take effect.

    3. Exit Server Manager or SQL*Plus.

    4. Now you should be able to do a full database export.

  6. #6
    Join Date
    Feb 2002
    Posts
    41
    -----------
    Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
    PL/SQL Release 8.0.5.0.0 - Production
    CORE Version 4.0.5.0.0 - Production
    TNS for Solaris: Version 8.0.5.0.0 - Production
    NLSRTL Version 3.3.2.0.0 - Production

    ----------

    Many thanks fellows.

    I will give stecal suggestion a go, and let you know if it works.

  7. #7
    Join Date
    Feb 2002
    Posts
    41
    What about ORA-02083. Will this solve that problem too?

  8. #8
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Yes it should. They are related errors.
    -- Dilip

  9. #9
    Join Date
    Feb 2002
    Posts
    41

    Exclamation

    stecal, export terminated successfully...

    Now I'm getting the following error while importing AQ_MANAGER's objects:

    ------
    . . importing table "MSG_MULTI"kgefec: fatal error 0

    IMP-00058: ORACLE error 21503 encountered
    ORA-21503: program terminated by fatal error
    IMP-00028: partial import of previous table rolled back: 89809 rows rolled back

    -----

    Would this be a serious error? Could it be ignored?

    Many thanks.

  10. #10
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Yes. No.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

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