14.3.1 impdp command line options

Source: Internet
Author: User

Keyword description (default)
Attach connects to an existing job, for example, attach [= job name].
Content specifies the data to be loaded. The valid keyword is:
(All), data_only and metadata_only.
Directory is the directory object used for dumping files, log files, and SQL files.
Dumpfile: the list of dump files to be imported from (expdat. dmp,
For example, dumpfile = scott1.dmp, scott2.dmp, dmpdir: scott3.dmp.
Encryption_password is the key word used to access the encrypted column data.
This parameter is invalid for network import jobs.
Estimate calculates the estimated job value. The valid keyword is:
(Blocks) and statistics.
Exclude is used to exclude specific object types, such as exclude = table: EMP.
Flashback_scn is used to set the session snapshot back to the SCN in the previous state.
Flashback_time is used to obtain the SCN time closest to the specified time.
Full import all objects from the source (y ).
Help displays the help message (n ).
Include includes specific object types, such as include = table_data.
The name of the import job to be created in job_name.
Logfile Log File Name (import. Log ).
The name of the remote database to which network_link is linked.
Nologfile does not write log files.
Parallel changes the number of active workers of the current job.
Parfile specifies the parameter file.
Query is the predicate clause used to import a subset of a table.
Remap_datafile redefines data file references in all DDL statements.
Remap_schema loads objects in one scheme to another.
Remap_tablespace remaps a tablespace object to another tablespace.
Reuse_datafiles if the tablespace already exists, initialize it (n ).
List of schemas import schemes.
Skip_unusable_indexes skips indexes that are set to useless indexes.
Sqlfile writes all SQL DDL statements to the specified file.
When the default value (0) shows the new status when available,
The frequency (in seconds) job status to be monitored.
Streams_configuration enable stream metadata Loading
The operation performed when the table_exists_action import object already exists.
Valid keywords: (skip), append, replace, and truncate.
Tables identifies the list of tables to be imported.
Tablespaces identifies the list of tablespaces to be imported.
Transform must be applied to the metadata conversion of applicable objects.
Valid conversion keywords: segment_attributes, storage
Oid and pctspace.
Transport_datafiles: list of data files imported in transmission mode.
Transport_full_check verifies the storage segments of all tables (n ).
The list of tablespaces from which transport_tablespaces will load metadata.
Valid only for the network_link mode import operation.
The version of the object to be exported. The valid keyword is:
(Compatible), latest or any valid database version.
Valid only for network_link and sqlfile.

The following commands are valid in interactive mode.
Note: abbreviations are allowed.

Command description (default)
Continue_client returns to record mode. If the job is idle, the job is restarted.
Exit_client exits the Client Session and keeps the job running.
Help summarizes interactive commands.
Kill_job separates and deletes jobs.
Parallel changes the number of active workers of the current job.
Parallel = <number of workers>.
Start_job start/restore the current job.
Start_job = skip_current will be skipped before the job starts
Any operation performed when the job is stopped.
When the default value (0) shows the new status when available,
The frequency (in seconds) job status to be monitored.
Status [= interval]
Stop_job closes the executed job in sequence and exits the client.
Stop_job = immediate will be closed immediately
Data pump operation.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.