object %
the documentation implies it can be used to clean up AQ - it cannot be used to
clean up AQ.
Make sure you have a valid backup.
Run the following statements as SYS.
SQL> delete from sys.exppkgact$
where package = 'DBMS_AQ_EXP_QUEUE_TABLES'
or package = 'DBMS_AQ_EXP_INDEX_TABLES'
or package = 'DBMS_AQ_EXP_TIMEMGR_TABLES'
or package = 'DBMS_AQ_EXP_HISTORY_TABLES'
or package = 'DBMS_AQ_EXP_SUBSCRIBER_TABLES';
SQL> delete from sys.exppkgobj$ where package = 'DBMS_AQ_EXP_QUEUES';
SQL> commit;
Rerun the export
Reference:
Bug:1662274 OUTSTANDING IMPORT/EXPORT ERRORS
.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7104/viewspace-1010279/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
纪念外婆
请登录后发表评论
登录
全部评论
