how to enter the EXPORT MODE(INTERACTIVE MODE)

Oracle 10g的新工具expdp 很强大,但是有一点没有习惯的是, 如何去撤销这个expdp 呢?

在以前的exp中, ctrl+c 就可以撤销前的exp 进程,但是在expdp中,ctrl+c只是将当前的进程转化为后台进程,也就是说,ctrl+c 并没有撤销expdp的进程,在背景端,还在运行中,此时,dumpfile, logfile是不可以上出,不可以更名的。

那么如何撤销一个expdp的进程呢?
进入interactive mode, 然后kill_job

step 1: using interacitve mode
S:\>set oracle_sid=ora1
S:\>expdp ‘/ as sysdba’ attach

Export: Release 10.2.0.4.0 – 64bit Production on Thursday, 21 May, 2009 0:55:59

Copyright (c) 2003, 2007, oracle.  All rights reserved.

Connected to: oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit
Production
With the oracle Label Security, OLAP, Data Mining and Real Application Testing o
ptions
EXPORT>

看到EXPORT> 就表示进入了interactive mode了,这个时候就可以用如下指令来进行操作了

The following commands are valid while in interactive mode.
Note: abbreviations are allowed

Command               Description (Default)
——————————————————————————
CONTINUE_CLIENT       Return to logging mode. Job will be re-started if idle.
EXIT_CLIENT           Quit client session and leave job running.
HELP                  Summarize interactive commands.
KILL_JOB              Detach and delete job.
PARALLEL              Change the number of active workers for current job.
                      PARALLEL=<number of workers>.
START_JOB             Start/resume current job.
                      START_JOB=SKIP_CURRENT will start the job after skipping
                      any action which was in progress when job was stopped.
STATUS                Frequency (secs) job status is to be monitored where
                      the default (0) will show new status when available.
                      STATUS[=interval]
STOP_JOB              orderly shutdown of job execution and exits the client.
                      STOP_JOB=IMMEDIATE performs an immediate shutdown of the
                      Data Pump job.

for example

EXPORT> status

其中KILL_JOB就是删除当前的expdp的job. stop_job仅仅是停止这个job, 还是可以重新start起来的。

发表评论?

0 条评论。

发表评论


注意 - 你可以用以下 HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>