-
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
-
-
I wish I had a metalink user, but then again I don't.
Any other suggestion?
-
-
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.
-
-----------
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.
-
What about ORA-02083. Will this solve that problem too?
-
Yes it should. They are related errors.
-- Dilip
-
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|