ORA-31626 是 Oracle Data Pump 导入 (impdp) 过程中常见的一个错误,通常与指定的目录对象(directory object)的权限或路径设置有关。以下是针对此错误的一些详细解答和建议解决步骤: 1. 确认 impdp 命令的具体错误信息 首先,需要查看 impdp 命令执行时提供的完整错误信息。错误信息通常会指出问题所在,例如目录对象不...
这可能是由于数据库权限配置不当,导致导出进程无法访问相关的表空间和对象。解决方案是检查用户权限设置,确保用户拥有足够的权限来执行数据导出操作。 作业不存在:ORA-31626错误表示尝试操作的作业不存在。这可能是由于指定的作业名称不正确或者作业已经被删除或更改。需要检查作业名称的拼写和准确性,并确保作业存在且具有...
DataPump import (Impdp) fails with errors like the following: UDI-00008: operation generated ORACLE error 31626ORA-31626: job does not existORA-06512: at "SYS.KUPC$QUE_INT", line 536ORA-25254: time-out in LISTEN while waiting for a message Changes NONE Cause Sign In To view full detai...
ORA-31626: job does not exist ORA-31638: cannot attach to job SYS_EXPORT_TABLE_01 for user TEST ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT_INT", line 428 ORA-39077: unable to subscribe agent KUPC$A_1_110703612385000 to queue "KUPC$C_1_20140808110703...
Oracle Database - Standard Edition - バージョン 12.1.0.1 以降: IMPDP 実行時に ORA-31626、ORA-31637、ORA-1422 エラーが発生し、失敗する
ORA-31626: job does not exist ORA-31638: cannot attach to job SYS_EXPORT_TABLE_01 for user SYS ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT_INT", line 428 ORA-39077: unable to subscribe agent KUPCA_1_191136568928000 to queue "KUPCC_1_20140807191136" ...
Kill, cancel, resume or restart datapump expdp and impdp jobs (ORA-31626, ORA-31633, ORA-06512, ORA-00955) - Oracle 48 convert expdp dmp file to SQL DDL statements 如何清除 DBA_DATAPUMP_JOBS 视图中的异常数据泵作业?(文档 ID 1626201.1)...
在使用impdp命令后,输入用户名密码,然后就报以下错误:连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsORA-31626: 作业不存在ORA-31637: 无法创建作业 SYS_IMPORT_FULL_01 (用户 DCQCMS)ORA-06512: 在 "SYS.DBMS_SYS_ERROR...
ORA-31626: job does not existORA-31638: cannot attach to jobSYS_EXPORT_TABLE_01foruserSYSORA-06512: at"SYS.DBMS_SYS_ERROR", line95ORA-06512: at"SYS.KUPV$FT_INT", line428ORA-39077: unable to subscribe agentKUPC$A_1_191136568928000 to queue"KUPC$C_1_20140807191136"ORA-06512: at"SYS...
UDI-31626: operation generated ORACLE error 31626 ORA-31626: job does not exist ORA-39086: cannot retrieve job information ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551 ORA-06512: at line 1 ...