Cloning a schema containing AQ$_ Tables
Hi,
I have schemas named XMA & REPOSITORY on 10gRel2 database instance named IMRDEV. I need to clone them to another database instance named IMRDEV2. I am using EXPDP and IMPDP. XMA schema contains AQ$ Queue Tables i.e.
imrdev-SQL> select object_type, count(*) from dba_objects where owner='XMA' and object_name like 'AQ$_%' group by object_type order by 1;
OBJECT_TYPE COUNT(*)
------------------- ----------
EVALUATION CONTEXT 3
INDEX 38
QUEUE 22
SEQUENCE 3
TABLE 19
VIEW 50
6 rows selected.
Following command was used to export the schemas:
nohup expdp system/passwd@imrdev schemas=REPOSITORY,XMA directory=EXPDP_DIR dumpfile=expdp_repository_xma_19Jan12.dmp logfile=expdp_repository_xma_19Jan12.log &
Following command was used to import the schemas:
nohup impdp system/passwd@imrdev2 directory=EXPDP_DIR dumpfile=expdp_repository_xma_19Jan12.dmp logfile=impdp_repository_xma_19Jan12.log &
I see following errors in my log...
...
ORA-31693: Table data object "XMA"."TBL_EACC_SPG_FA_REQ" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-39779: type "SYS"."AQ$_JMS_TEXT_MESSAGE" not found or conversion to latest version is not possible
ORA-31693: Table data object "XMA"."XMA_7_IN_QT" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-39779: type "SYS"."AQ$_JMS_TEXT_MESSAGE" not found or conversion to latest version is not possible
ORA-31693: Table data object "XMA"."TBL_EACC_WO_REQ" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
...
I want to know what is the best way to clone schemas containing Oracle AQ stuff...
regards,
--
Anjum