-
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.
-
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.
-
-
From Oracle Database Forum (same error):
Are you trying to do import with COMMIT=N option?
What is your buffer size in import command?
What is the size of your export dump?
If you have big tables, you may want to try with commit=Y, buffer=30m or 50m (try with 50m first)
Create a big rollback segment and make all other rollback segment offline except system.
-
jeje...
I've tried reducing the size of the buffer, but problem remains..
Any other clue?
TIA
-
Is the Import process's memory is growing when it's running?
If the error is happening on a large table, you might consider partitioning the table then export/import the parts
From the information I can gather, this is a bug fixed in 8.1.7 (although the error notes are from 8.1.6 not 8.0.5)
Best of luck to you.
-
Ken
Thank you very much.
I'll try to see what I can do about it.
Nevertheless, table size would not be a problem as import of larger tables had succeeded.
AFIK that table seems to be related with some sort of database sync. with remote nodes, which is said to be offline. So I'm thinking about excluding that particular schema.
Thanks again.
-
By the way... How do I reset Advanced Queuing?, i.e. remove all AQ's records and start from scratch.
Thanks !
-
Arda,
I'm glad you think you have the solution.
I recommend purchasing a support contract and access to Metalink.
Isn't AQ called Streams now?
