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
I wish I had a metalink user, but then again I don't.
Any other suggestion?
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.
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:
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 22.214.171.124.0 - Production
PL/SQL Release 126.96.36.199.0 - Production
CORE Version 188.8.131.52.0 - Production
TNS for Solaris: Version 184.108.40.206.0 - Production
NLSRTL Version 220.127.116.11.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.
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?
Click Here to Expand Forum to Full Width