2
4

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

DataPumpのexpdp を停止→再開

Last updated at Posted at 2017-09-14

途中でインポート停止して、再開したい場合の手順を残します。
※注意:もし、実行する際は自己責任でお願いいたします。

いや~以前、impdpでインポート中に表領域が足りなくなって、途中停止せざる追えなくて、焦ったので今後のために手順記載します。

--1,ジョブ名確認
set linesize 200
col owner_name for a10
col job_name for a20
col operation for a10
col job_mode for a10
col state for a12
col degree for 999
col attached_sessions for 999
col datapump_sessions for 999

SQL>select * from dba_datapump_jobs;

--2,ジョブ停止する場合
$impdp system/xxxx attach=SYS_IMPORT_TABLE_01

--3,ジョブを完全停止
impdp system/xxxx attach=SYS_IMPORT_TABLE_01
Import> kill_job

以上、

2
4
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
2
4

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?