Prev | Current Page 621 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

Use the command-line parameters to specify the import mode and the locations for all the
files. You can store the parameter values in a parameter file and then reference the file via the
PARFILE option.
In the first export example of this chapter, using the RJB schema, the parameter file named rjb_
dp.par (copied to the destination and renamed to rjb_dp_imp.par) contained the following entries:
directory=dpxfer
dumpfile=metadata_only.dmp
content=metadata_only
If the Oracle directory object has the same name on the target database, you can re-use
the same parameter file. To create the RJB schema??™s objects in a different schema on the target
database, use the REMAP_SCHEMA parameter as follows:
REMAP_SCHEMA=source_schema:target_schema
You can change the destination tablespace as well using the REMAP_TABLESPACE option.
Before starting the import, create a new user KFC as follows:
SQL> grant resource, connect to kfc identified by kfc;
Grant succeeded.
SQL>
Next, add the REMAP_SCHEMA parameter to the end of the parameter file you copied from
the source database:
directory=dpxfer
dumpfile=metadata_only.dmp
Parameter Description
CONTINUE_CLIENT Exits the interactive mode and enter logging mode. The job will
be restarted if idle.
EXIT_CLIENT Exits the client session, but leave the server Data Pump Import
job running.
HELP Displays online help for the import.
KILL_JOB Kills the current job and detach related client sessions.


Pages:
609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633
Spa Ciechocinek drzwiowe hosting hotele londyn xiden.bosten.pl