Prev | Current Page 609 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

If you specify a
name for the job via the JOB_NAME parameter, you must be certain that the job name will not
conflict with the name of any table or view in your schema. During Data Pump jobs, Oracle will
create and maintain a master table for the duration of the job. The master table will have the same
name as the Data Pump job, so its name cannot conflict with existing objects.
While a job is running, you can execute the commands listed in Table 11-2 via Data Pump??™s
interface.
Parameter Description
NOLOGFILE A Y/N flag is used to suppress log file creation.
PARALLEL Sets the number of workers for the Data Pump Export job.
PARFILE Names the parameter file to use, if any.
QUERY Filters rows from tables during the export.
REMAP_DATA Specifies a function that can transform a column or columns
in the data, for testing or masking sensitive data.
REUSE_DUMPFILES Overwrites existing dumpfiles.
SAMPLE Specifies a percentage of the data blocks to easily select a
percentage of the rows in each table.
SCHEMAS Names the schemas to be exported for a Schema mode
export.
STATUS Displays detailed status of the Data Pump job.
TABLES Lists the tables and partitions to be exported for a Table mode
export.
TABLESPACES Lists the tablespaces to be exported.
TRANSPORT_FULL_CHECK Specifies whether the tablespaces being exported should first
be verified as a self-contained set.
TRANSPORT_TABLESPACES Specifies a Transportable Tablespace mode export.


Pages:
597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621
drukarki fiskalne kraków willa karmazyn międzyzdroje www.books61.hobbitstory.com terapia magnetyczna Informacje o hostingu