expdp不能通过attach连接job

通过attach连接时，不能正常连接：

[oracle@alios dpdump]$ expdp \'/ as sysdba\' attach=SYS_EXPORT_SCHEMA_05

Export: Release 19.0.0.0.0 - Production on Tue May 7 13:04:14 2024
Version 19.16.0.0.0

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Job: SYS_EXPORT_SCHEMA_05
Owner: SYS
Operation: EXPORT
Creator Privs: TRUE
GUID: 17E111CE931F0CBDE065633A09D688E2
Start Time: Tuesday, 07 May, 2024 13:03:39
Mode: SCHEMA
Instance: orcl
Max Parallelism: 1
Timezone: +00:00
Timezone version: 32
Endianness: LITTLE
NLS character set: US7ASCII
NLS NCHAR character set: AL16UTF16
EXPORT Job Parameters:
Segmentation fault (core dumped)
或者

Job: SYS_EXPORT_TABLE_3
Owner: SYS
Operation: EXPORT
Creator Privs: TRUE
GUID: 17CB7C63CA88F491E0630101640A291E
Start Time: Monday, 06 May, 2024 23:11:39
Mode: TABLE
Instance: orcl1
Max Parallelism: 2
EXPORT Job Parameters:
段错误

这是由于用存储过程发起的备份，如果需要attach连接上去处理必须也要存储过程，比如停止备份操作：

先查询出运行种的job：

SELECT owner_name, job_name, rtrim(operation) "OPERATION",
rtrim(job_mode) "JOB_MODE", state, attached_sessions
FROM dba_datapump_jobs;

然后停止：

declare
h1 NUMBER;
BEGIN
h1 := DBMS_DATAPUMP.ATTACH('SYS_EXPORT_SCHEMA_02','SYS');
DBMS_DATAPUMP.STOP_JOB(h1);
END;
/

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若转载，请注明出处：http://www.mfbz.cn/a/604325.html

如若内容造成侵权/违法违规/事实不符，请联系我们进行投诉反馈qq邮箱809451989@qq.com，一经查实，立即删除！