==结尾的回收站的,不要管。
其他是和datapump有关的对象,可以尝试如下步骤,如果expdp/impdp没问题就不用管:
-- 1.Catdph.sql will Re-Install DataPump types and views
SQL> @$ORACLE_HOME/rdbms/admin/catdph.sql
-- Note:
-- If XDB is installed, then it is required to run "catmetx.sql" script also.
-- Use this code to verify if XDB is installed:
SQL> select substr(comp_name,1,30) comp_name,
substr(comp_id,1,10) comp_id,
substr(version,1,12) version,
status
from dba_registry;
-- Sample output if XDB installed,
Oracle XML Database XDB -version- VALID
-- 2.prvtdtde.plb will re-install tde_library packages
SQL> @$ORACLE_HOME/rdbms/admin/prvtdtde.plb
-- 3. Catdpb.sql will Re-Install DataPump packages
SQL> @$ORACLE_HOME/rdbms/admin/catdpb.sql
-- 4.Dbmspump.sql will Re-Install DBMS DataPump objects
SQL> @$ORACLE_HOME/rdbms/admin/dbmspump.sql
-- 5. To recompile invalid objects, if any
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
评论
有用 0您好,根据您给出的步骤依次操作后,结果仍然是一样的。尝试了下expdp导出会报错
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 672
ORA-39080: failed to create queues "KUPC$C_1_20190418163728" and "" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1606
ORA-24203: operation failed, queue table SYS.KUPC$DATAPUMP_QUETAB has errors
评论
有用 0执行哪些步骤是否报错?看看SYS.KUPC$DATAPUMP_QUETAB这个表在不在
评论
有用 0
评论
有用 0
墨值悬赏

