Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to terminate expdp normally". In daily operation, I believe many people have doubts about how to terminate expdp normally. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the doubts of "how to terminate expdp normally". Next, please follow the editor to study!

1. First query the job_name corresponding to expdp

SQL > select * from dba_datapump_jobs

OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS

Job_name tasks checked out above by 2.attach

$expdp username/password attach=SYS_EXPORT_FULL_01

In the above command, username is the owner_name column value of the query result in step 1, passwd is the password of the username, and sys_export_full_01 is the job_name in the query result in step 1 above.

3. Stop or detach and delete the tasks corresponding to the job_name found above

Export > stop_job

-reply to yes in the next steps

Export > kill_job

-reply to yes in the next steps

4. Enter interactive mode

$expdp username/password...

To run the above data pump command, type CTL+C to enter interactive mode, which is the same under windows and LINUX. Once in interactive mode, you can run the following interactive commands.

5. Common commands in interactive mode

1) CONTINUE_CLIENT: return to record mode. If idle, the job will be restarted.

2) START_JOB: start the recovery of the current job.

3) STATUS: how often the job status is monitored (in seconds), where the default value [0] means that the new status is displayed as soon as it is available, for example: STATUS= [interval].

4) STOP_JOB: sequentially closes the executed job and exits the client.

5) STOP_JOB=IMMEDIATE: the data pump job will be closed immediately.

6) ADD_FILE: add a dump file to the dump file set, for example: ADD_FILE=dirobjdumpfile-name.

7) EXIT_CLIENT: exit the client session and leave the job running.

8) HELP: summarize interactive commands.

9) KILL_JOB: detach and delete jobs.

10) PARALLEL: change the number of active worker for the current job, for example: PARALLEL=worker.

11) TART_JOB: starts the recovery of the current job.

At this point, the study on "how to terminate expdp normally" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.