1. ORA-31638错误的含义 ORA-31638错误的全文是:“ORA-31638: cannot attach to job <job_name> for user <user_name>”。这个错误表明Data Pump导出(expdp)或导入(impdp)操作无法连接到指定的作业(job),通常是因为作业不存在或用户没有足够的权限去访问该作业。 2. ORA-31638错误可能的原因 作业名称错误:指...
在执行Oracle EXPDP命令时，若遇到输入密码后报ORA-31626,ORA-31638,ORA-39077等错误，可能由于数据库连接或系统环境存在差异引起。具体错误信息和操作步骤如下：执行命令：[oracle@easdb2 ~]$ expdp \'/ as sysdba\' directory=OABAK dumpfile=oabak.dmp full=y 版本信息：Export: Release 19.0.0...
ORA-31626: job does not exist ORA-31638: cannot attach to job SYS_EXPORT_FULL_01 for user SYS ORA-06512: at "SYS.KUPV$FT", line 1142 ORA-06512: at "SYS.KUPV$FT", line 1744 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT_INT", line 498 ORA-39077:...
ORA-31638: cannot attach to job SYS_EXPORT_SCHEMA_01 for user SYSTEM 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_134100540660000 to queue "KUPC$C_1_20140928134059" ORA-06512: at "SYS.DBMS_...
expdp 导出 ORA-31638 ORA-25448 错误处理 expdp 导出报如下错误：[oracle@dg1 ~]$ expdp directory=backup dumpfile=user.dmplogfile=user.log schemas=dave Export: Release 11.2.0.3.0 - Production onThu Aug 28 00:28:34 2014 Copyright (c) 1982, 2011, Oracle and/or itsaffiliates. All ...
expdp 导出报如下错误: [oracle@dg1 ~]$ expdp directory=backup dumpfile=user.dmplogfile=user.log schemas=dave Export: Release 11.2.0.3.0 - Production onThu Aug 28 00:28:34 2014 Copyright (c) 1982, 2011, Oracle and/or itsaffiliates. All rights reserved. ...
导数据遇到ORA-31626/ORA-31638/ORA-39077/ORA-6502 报错信息如下: [oracle@vm010148 ~]$ expdp system/oracle directory=dir dumpfile=full.dmp logfile=full.log Export: Release 11.2.0.3.0 - Production on Sun Sep 28 13:40:59 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All ...
导数据遇到ORA-31626/ORA-31638/ORA-39077/ORA-6502 报错信息如下: [oracle@vm010148 ~]$ expdp system/oracle directory=dir dumpfile=full.dmp logfile=full.log Export: Release 11.2.0.3.0 - Production on Sun Sep 28 13:40:59 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All ...