expdp不能通过attach连接job

来源:这里教程网 时间:2026-03-03 19:54:23 作者:

[oracle@alios dpdump]$ expdp \'/ as sysdba\' attach=SYS_EXPORT_SCHEMA_05Export: Release 19.0.0.0.0 - Production on Tue May 7 13:04:14 2024 Version 19.16.0.0.0Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionJob: 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; /

相关推荐