par
Press CTRL-C to leave the log display, and Data Pump Import will return you to the import prompt:
Import>
Exit to the operating system using the exit_client command:
Import> exit_client
Later, you can restart the client and attach to the currently running job under your schema:
impdp rjb/rjb attach
If you gave a name to your Data Pump Import job, specify the name as part of the attach
parameter. When you attach to a running job, Data Pump Import will display the status of the
job??”its basic configuration parameters and its current status. You can then issue the continue_
client command to see the log entries as they are generated, or you can alter the running job.
Import> continue_client
Not surprisingly, you can temporarily stop a job using the stop_job command:
Import> stop_job
While the job is stopped, you can increase its parallelism via the parallel option, and then
restart the job:
Import> start_job
EXCLUDE, INCLUDE, and QUERY
Data Pump Import, like Data Pump Export, allows you to restrict the data processed via the use of
the EXCLUDE, INCLUDE, and QUERY options, as described earlier in this chapter. Because you
can use these options on both the export and the import, you can be very flexible in your imports.
For example, you may choose to export an entire table but only import part of it ??”the rows that
match your QUERY criteria. You could choose to export an entire schema but when recovering
the database via import include only the most necessary tables so that the application downtime
can be minimized.
Pages:
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636