Oracle expdp command usage

Related Parameters and export examples:

1. DIRECTORY

Specifies the directory where the dump and log files are located

DIRECTORY = directory_object

Directory_object is used to specify the DIRECTORY object name. Note that the DIRECTORY object is an object created using the create directory statement, not an OS DIRECTORY.

Expdp scott/tiger DIRECTORY = dmp dumpfile = a. dump

Create or replace directory dmp

As 'd:/dmp'

Expdp zftang/zftang @ zftang directory = dmp dumpfile = test. dmp content = metadata_only

2. CONTENT

This option is used to specify the content to be exported. The default value is ALL.

CONTENT = {ALL | DATA_ONLY | METADATA_ONLY}

When the CONTENT is set to ALL, only the object data is exported when the definition of the exported object and ALL its data is set to DATA_ONLY. If the value is METADATA_ONLY, only the object definition is exported.

Expdp zftang/zftang @ zftang directory = dmp dumpfile = test. dmp content = metadata_only

---------- Export object definitions only

Expdp zftang/zftang @ zftang directory = dmp dumpfile = test. dmp content = data_only

---------- Export all data

3. DUMPFILE

Specifies the name of the dump file. The default name is expdat. dmp.

DUMPFILE = [directory_object:] file_name [,…]

Directory_object is used to specify the DIRECTORY object name, And file_name is used to specify the dump file name. Note that if directory_object is not specified, the export tool automatically uses the DIRECTORY object specified by the DIRECTORY option.

Expdp zftang/zftang @ zftang directory = dmp dumpfile = test1.dmp

Steps for Data Pump tool export:

1. create DIRECTORY

Create directory dir_dp as 'd:/Oracle/dir_dp ';

2. Authorization

Grant read, write on directory dir_dp to zftang;

-- View directories and permissions

SELECT privilege, directory_name, DIRECTORY_PATH FROM user_tab_privs t, all_directories d

WHERE t. table_name (+) = d. directory_name order by 2, 1;

3. Execute Export

Expdp zftang/zftang @ fgisdb schemas = zftang directory = dir_dp dumpfile = expdp_test1.dmp logfile = expdp_test1.log;

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1

With the Partitioning, OLAP and Data Mining options

Start "ZFTANG". "SYS_EXPORT_SCHEMA_01": zftang/******** @ fgisdb sch

Ory = dir_dp dumpfile = expdp_test1.dmp logfile = expdp_test1.log ;*/

Note:

1. directory = dir_dp must be placed before, if placed last, will prompt ORA-39002: The operation is not valid

ORA-39070: Unable to open the log file.

ORA-39087: Invalid directory name DATA_PUMP_DIR;

2. During the export process, data dump creates and uses an object named SYS_EXPORT_SCHEMA_01, which is the JOB name used in the data dump export process, if you do not specify the name of the exported JOB when executing this command, a default JOB name is generated. If you specify the JOB name during the export process

Change it:

Expdp zftang/zftang @ fgisdb schemas = zftang directory = dir_dp dumpfile = expdp_test1.dmp logfile = expdp_test1.log, job_name = my_job1;

3. Do not use semicolons after the export statement. Otherwise, the job table name in the preceding Export Statement is 'my _ job1; 'instead of my_job1. Therefore, when the command expdp zftang/zftang attach = zftang. my_job1 is executed, it always prompts that the job table cannot be found.

1 2 Next Page