Prev | Current Page 619 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"


REMAP_DATAFILE Changes the name of the source datafile to the target datafile in the create
library, create tablespace, and create directory commands during the import.
REMAP_SCHEMA Imports data exported from the source schema into the target schema.
REMAP_TABLE Renames a table during import.
REMAP_TABLESPACE Imports data exported from the source tablespace into the target tablespace.
REUSE_DATAFILES Specifies whether existing datafiles should be reused by create tablespace
commands during Full mode imports.
SCHEMAS Names the schemas to be exported for a Schema mode import.
TABLE 11-3 Data Pump Import Command-Line Parameters
Chapter 11: Backup and Recovery Options 405
NOTE
The directory for the dump file and log file must already exist; see the
prior section on the create directory command.
Table 11-4 lists the parameters that are valid in the interactive mode of Data Pump Import.
Many of the Data Pump Import parameters are the same as those available for the Data Pump
Export. In the following sections, you??™ll see how to start an import job, along with descriptions
of the major options unique to Data Pump Import.
Parameter Description
SKIP_UNUSABLE_INDEXES A Y/N flag. If set to Y, the import does not load data into tables whose indexes
are set to the Index Unusable state.
SQLFILE Names the file to which the DDL for the import will be written. The data and
metadata will not be loaded into the target database.


Pages:
607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631
Wczasy nad morzem kasyno kino azjatyckie bwin out of home advertising