Prev | Current Page 622 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"


PARALLEL Alters the number of workers for the Data Pump Import job.
START_JOB Restarts the attached job.
STATUS Displays detailed status of the Data Pump job.
STOP_JOB Stops the job for later restart.
TABLE 11-4 Interactive Parameters for Data Pump Import
Chapter 11: Backup and Recovery Options 407
content=metadata_only
remap_schema=RJB:KFC
NOTE
All dump files must be specified at the time the job is started.
You are now ready to start the import job. Because you are changing the original owner of
the schema, you must have the IMP_FULL_DATABASE system privilege. Data Pump Import jobs
are started using the impdp utility; here is the command, including the revised parameter file:
impdp system/verylongpassword parfile=dp_rjb_import.par
Oracle will now perform the import and display its progress. Because the NOLOGFILE option
was not specified, the log file for the import will be placed in the same directory as the dump file
and will be given the name import.log. You can verify the success of the import by logging into
the KFC schema and reviewing the objects. Here is the log file from the impdp command:
[oracle@oc1 ~]$ impdp rjb/rjb parfile=dp_rjb_import.par
Import: Release 11.1.0.6.0 - Production
on Saturday, 25 August, 2007 13:22:07
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition
Release 11.1.0.6.0 ??“ Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Master table "RJB".


Pages:
610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634
ciekawe zdania zasady pokera Titan Poker judo łódź poker w internecie