CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DataPump Utility

Version 11.1
 
Exporting Schemas
Related Dynamic Views
datapump_object_connnect gv$datapump_job gv$datapump_session

Export Modes
Mode Description
Full Use the FULL parameter: Exports the entire database is unloaded. EXP_FULL_DATABASE role required.
Schema Use the SCHEMAS parameter: The default export mode. If you have the EXP_FULL_DATABASE role, then you can specify a list of schemas and optionally include the schema definitions themselves, as well as system privilege grants to those schemas. If you do not have the EXP_FULL_DATABASE role, you can export only your own schema.
Table Use the TABLES parameter. A specified set of tables, partitions, and their dependent objects are unloaded. You must have the EXP_FULL_DATABASE role to specify tables that are not in your own schema. All specified tables must reside in a single schema. Note that type definitions for columns are not exported in table mode. It is expected that the type definitions already exist in the target instance at import time.
Tablespace Use the TABLESPACES parameter. Only tables contained in a specified set of tablespaces are unloaded. If a table is unloaded, its data, metadata, and dependent objects are also unloaded. In tablespace mode, if any part of a table resides in the specified set, then that table and all of its dependent objects are exported. Privileged users get all tables. Nonprivileged users get only the tables in their own schemas.
Transportable Tablespace Use the  TRANSPORT_TABLESPACES parameter. In transportable tablespace mode, only the metadata for tables, and dependent objects, within a specified set of tablespaces are unloaded. EXP_FULL_DATABASE role required.Degree of parallelism must = 1.

Demo Setup
conn / as sysdba

desc dba_directories

col owner format a10
col directory_path format a70

SELECT * FROM dba_directories;

CREATE OR REPLACE DIRECTORY data_pump_dir AS 'c: emp';
-- default is $ORACLE_BASE/admin/<database_name>/dpdump

GRANT export full database TO uwclass;
 
Basic Export Types
Note: After each export, SELECT table_name FROM user_tables in the schema that ran the export, in the following examples, uwclass or abc. You will find tables with names such as SYS_EXPORT_FULL_01 and SYS_EXPORT_SCHEMA_01. Examine their contents
Full Export FULL=<N | Y>
expdp uwclass/uwclass DIRECTORY=data_pump_dir DUMPFILE=demo01.dmp FULL=y
Schema Export SCHEMAS=<schema_name_list>
expdp uwclass DIRECTORY=data_pump_dir DUMPFILE=demo02.dmp SCHEMAS=uwclass,scott
Table Export TABLES=<[schema_name.]table_name[:partition_name] [, ...]>
expdp uwclass/uwclass DUMPFILE=data_pump_dir:demo03.dmp
TABLES=servers, serv_inst
Tablespace Export TABLESPACES=<tablespace_list>
expdp uwclass DUMPFILE=data_pump_dir:demo04.dmp TABLESPACES=uwclass,users TRANSPORT_FULL_CHECK=y

Transportable Tablespace Export
TRANSPORT_TABLESPACES=<tablespace_name [, ...]>

The default tablespace of the user performing the export must not be set to one of the tablespaces being transported
expdp uwclass/uwclass DIRECTORY=data_pump_dir DUMPFILE=demo05.dmp
TRANSPORT_TABLESPACES=users,example TRANSPORT_FULL_CHECK=y LOGFILE=demo5.log

conn / as sysdba

ALTER TABLESPACE users READ ONLY;
ALTER TABLESPACE example READ ONLY;

expdp uwclass/uwclass DIRECTORY=data_pump_dir DUMPFILE=demo05.dmp
TRANSPORT_TABLESPACES=users,example TRANSPORT_FULL_CHECK=y LOGFILE=demo5.log

ALTER TABLESPACE users READ WRITE;
ALTER TABLESPACE example READ WRITE;
 
Additional Export Parameters
Attach Demo ATTACH=<[schema_name.]job_name>
expdp uwclass DIRECTORY=data_pump_dir DUMPFILE=demo06.dmp ATTACH=uw_job NOLOGFILE=y
Compression Demo COMPRESSION=<METADATA_ONLY | NONE>
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo07.dmp COMPRESSION=none
Content Demo CONTENT=<ALL | DATA_ONLY | METADATA_ONLY>
expdp uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo08.dmp CONTENT=metadata_only
Directory Demo DIRECTORY=<directory_object>
See FULL Demo
Dumpfile Demo DUMPFILE=<file_name.dmp> -- can be used more than 1X at once
See FULL Demo

Encryption Demo
Default: The default mode depends on which other encryption-related parameters are used. If only the ENCRYPTION parameter is specified, then the default mode is TRANSPARENT.

If the ENCRYPTION_PASSWORD parameter is specified and the Oracle Encryption Wallet is open, then the default is DUAL. If the ENCRYPTION_PASSWORD parameter is specified and the Oracle Encryption Wallet is closed, then the default is PASSWORD.

ENCRYPTION=<ALL|DATA_ONLY|ENCRYPTED_COLUMNS_ONLY|METADATA_ONLY|NONE>
ENCRYPTION_ALGORITHM=<AES128 | AES192 | AES256>
ENCRYPTION_MODE=<dual | password | transparent>
ENCRYPTION_PASSWORD=<user_supplied_pwd>
expdp uwclass/uwclass DIRECTORY=data_pump_dir DUMPFILE=demo09.dmp ENCRYPTION=all ENCRYPTION_ALGORITHM=aes256 ENCRYPTION_MODE=dual ENCRYPTION_PASSWORD=a1pha
Estimate Demo ESTIMATE=<BLOCKS | STATISTICS>
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo10.dmp ESTIMATE=blocks

expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo11.dmp ESTIMATE=statistics
Estimate Only Demo ESTIMATE_ONLY=<Y | N>
expdp uwclass/uwclass SCHEMAS=uwclass ESTIMATE_ONLY=y

open export.log with an editor

Exclude Demos
EXCLUDE=<exclude_criterion>
-- exclude all (nonreferential) constraints, except for NOT NULL constraints and any constraints needed for successful table creation and loading
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo12.dmp EXCLUDE=constraint

-- exclude referential integrity (foreign key) constraints
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo13.dmp EXCLUDE=ref_constraint

-- exclude object grants on all object types and system priv grants
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo14.dmp EXCLUDE=grant

-- excludes the definitions of users
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo15.dmp EXCLUDE=user

-- excludes views
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo16.dmp EXCLUDE=view,package,function

To exclude a specific user and all objects of that user, specify a filter such as the following (where hr is the schema name of the user you want to exclude):
expdp uwclass/uwclass FULL=y DIRECTORY=data_pump_dir DUMPFILE=demo17.dmp EXCLUDE=SCHEMA:\"='HR'\"
Filesize Demo FILESIZE<0 | integer[B | K | M | G]>

The default, zero, means unlimited
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo%U.dmp COMPRESSION=none FILESIZE=5M

Flashback SCN Demo
FLASHBACK_SCN=<scn_value>
conn / as sysdba

SELECT dbms_flashback.get_system_change_number FROM dual;

exit

expdp uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo18.dmp FLASHBACK_SCN=36477000

Flashback Time Demo
FLASHBACK_TIME=<timestamp_value>
conn / as sysdba

SELECT dbms_flashback.get_system_change_number
FROM dual;

SELECT SCN_TO_TIMESTAMP(dbms_flashback.get_system_change_number)
FROM dual;


exit

expdp uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo19.dmp FLASHBACK_TIME=\"TO_TIMESTAMP('01-SEP-2008 08:08:08', 'DD-MON-YYYY HH24:MI:SS')\"
Help Demo HELP=<Y | N>
expdp uwclass HELP=y

Include Demo
INCLUDE=<include_list>
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo20.dmp INCLUDE=table

expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo21.dmp INCLUDE=\"IN ('SERVERS', 'SERV_INST')\"

expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo22.dmp INCLUDE=procedure

expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo23.dmp INCLUDE=INDEX:\"LIKE 'PK%\"
Job Name Demo JOB_NAME=<job_or_master_table_name>
expdp uwclass DIRECTORY=data_pump_dir DUMPFILE=demo24.dmp JOB_NAME=uwjob
Logfile Demo LOGFILE=<export.log | directory_object:file_name>
expdp uwclass/uwclass SCHEMAS=uwclass DUMPFILE=data_pump_dir:demo25.dmp LOGFILE=data_pump_dir:demo25.log
Network Link Demo NETWORK_LINK=<source_database_link>
expdp uwclass DIRECTORY=data_pump_dir DUMPFILE=demo26.dmp NETWORK_LINK=fixed_user
No Logfile Demo NOLOGFILE=<N | Y>
expdp uwclass TABLES=servers, airplanes DUMPFILE=data_pump_dir:demo27.dmp NOLOGFILE=y
Parallel Demo PARALLEL=<1 | parallel_degree>
expdp uwclass TABLES=servers DUMPFILE=data_pump_dir:demo28.dmp PARALLEL=2

Parfile Demo
PARFILE=<[directory_object.]file_name>
-- create this as a text file in the data_pump_dir directory
TABLES=servers DUMPFILE=data_pump_dir:demo29.dmp
LOGFILE=data_pump_dir:demo29.log
PARALLEL=2

expdp uwclass PARFILE=data_pump_dir:parfile.par
Query Demo QUERY=<[schema.][table_name:]query_where_clause>
expdp uwclass TABLES=airplanes DUMPFILE=data_pump_dir:demo30.dmp QUERY=airplanes:\"WHERE program_id = ''737''\"

Remap Data Demo
REMAP_DATA=[schema.]tablename.column_name:[schema.]pkg.function
conn uwclass/uwclass

CREATE OR REPLACE PACKAGE remap IS
  FUNCTION timestwo (inval NUMBER) RETURN NUMBER;
END remap;
/


CREATE OR REPLACE PACKAGE BODY remap IS
  FUNCTION timestwo (inval NUMBER) RETURN NUMBER IS
  BEGIN
    RETURN inval*2;
  END timestwo;
END remap;
/

expdp uwclass TABLES=servers DUMPFILE=data_pump_dir:demo31.dmp REMAP_DATA=uwclass.servers.srvr_id:uwclass.remap.timestwo
Reuse Dump Files Demo REUSE_DUMPFILES=<N | Y>
expdp uwclass TABLES=servers DUMPFILE=data_pump_dir:demo32.dmp REUSE_DUMPFILES=Y
Sample Demo SAMPLE=<[[[schema_name.]table_name:]sample_percent>
expdp uwclass/uwclass TABLES=airplanes DUMPFILE=data_pump_dir:demo33.dmp SAMPLE=\"UWCLASS.AIRPLANES:10\"
Status Demo STATUS=<0 | seconds> -- how often job status is displayed
expdp uwclass/uwclass SCHEMAS=uwclass DUMPFILE=data_pump_dir:demo34.dmp STATUS=5
Transport Full Check Demo TRANSPORT_FULL_CHECK=<N | Y>
See TRANSPORT_TABLESPACES Demo
Version Demo VERSION=<COMPATIBLE | LATEST | version_string>
expdp uwclass/uwclass SCHEMAS=uwclass DUMPFILE=data_pump_dir:demo35.dmp VERSION=latest
 
Importing Schemas

Import Modes
Mode Description
Full Use the FULL parameter: Exports the entire database is unloaded. IMP_FULL_DATABASE role required.
Schema Use the SCHEMAS parameter: The default export mode. If you have the EXP_FULL_DATABASE role, then you can specify a list of schemas and optionally include the schema definitions themselves, as well as system privilege grants to those schemas. If you do not have the EXP_FULL_DATABASE role, you can export only your own schema.
Table Use the TABLES parameter. A specified set of tables, partitions, and their dependent objects are unloaded. You must have the EXP_FULL_DATABASE role to specify tables that are not in your own schema. All specified tables must reside in a single schema. Note that type definitions for columns are not exported in table mode. It is expected that the type definitions already exist in the target instance at import time.
Tablespace Use the TABLESPACES parameter. Only tables contained in a specified set of tablespaces are unloaded. If a table is unloaded, its data, metadata, and dependent objects are also unloaded. In tablespace mode, if any part of a table resides in the specified set, then that table and all of its dependent objects are exported. Privileged users get all tables. Nonprivileged users get only the tables in their own schemas.
Transportable Tablespace Use the  TRANSPORT_TABLESPACES parameter. In transportable tablespace mode, only the metadata for tables, and dependent objects, within a specified set of tablespaces are unloaded. EXP_FULL_DATABASE role required.Degree of parallelism must = 1.

Demo Setup
conn / as sysdba

desc dba_directories

col owner format a10
col directory_path format a70

SELECT * FROM dba_directories;

CREATE OR REPLACE DIRECTORY data_pump_dir AS 'c: emp';
-- default is $ORACLE_BASE/admin/<database_name>/dpdump

GRANT import full database TO uwclass;
 
Basic Import Types
Full Import FULL=<N | Y>
impdp uwclass/uwclass DIRECTORY=data_pump_dir DUMPFILE=demo01.dmp FULL=y

Schema Import
SCHEMAS=<schema_name_list>
SQL> conn / as sysdba

SQL> CREATE USER abc
     IDENTIFIED BY abc
     DEFAULT TABLESPACE users
     TEMPORARY TABLESPACE temp
     QUOTA unlimited ON users;

SQL> GRANT create session, create table TO abc;
SQL> GRANT read on directory data_pump_dir TO abc;
SQL> GRANT write on directory data_pump_dir TO abc;

SQL> conn abc/abc

SQL> CREATE TABLE zzyzx AS
     SELECT * FROM all_tables;

expdp uwclass/uwclass DUMPFILE=data_pump_dir:demo02.dmp SCHEMAS=abc

SQL> DROP TABLE zzyzx;

impdp uwclass/uwclass DUMPFILE=data_pump_dir:demo02.dmp SCHEMAS=abc

impdp abc DIRECTORY=data_pump_dir DUMPFILE=demo02.dmp SCHEMAS=abc

SQL> SELECT owner, object_type, created
     FROM dba_objects
     WHERE object_name = 'ZZYZX';
Table Import TABLES=<[schema_name.]table_name[:partition_name] [, ...]>
expdp uwclass/uwclass DUMPFILE=data_pump_dir:demo03.dmp
TABLES=servers, serv_inst
Tablespace Import TABLESPACES=<tablespace_list>
expdp uwclass DUMPFILE=data_pump_dir:demo04.dmp TABLESPACES=uwclass,users TRANSPORT_FULL_CHECK=y

Transportable Tablespace Import
TRANSPORT_TABLESPACES=<tablespace_name [, ...]>

The default tablespace of the user performing the export must not be set to one of the tablespaces being transported
expdp uwclass/uwclass DIRECTORY=data_pump_dir DUMPFILE=demo05.dmp
TRANSPORT_TABLESPACES=users,example TRANSPORT_FULL_CHECK=y LOGFILE=demo5.log

conn / as sysdba

ALTER TABLESPACE users READ ONLY;
ALTER TABLESPACE example READ ONLY;

expdp uwclass/uwclass DIRECTORY=data_pump_dir DUMPFILE=demo05.dmp
TRANSPORT_TABLESPACES=users,example TRANSPORT_FULL_CHECK=y LOGFILE=demo5.log

ALTER TABLESPACE users READ WRITE;
ALTER TABLESPACE example READ WRITE;
 
Additional Import Parameters
Attach Demo ATTACH=<[schema_name.]job_name>
impdp uwclass DIRECTORY=data_pump_dir DUMPFILE=demo06.dmp ATTACH=uw_job NOLOGFILE=y
Content Demo CONTENT=<ALL | DATA_ONLY | METADATA_ONLY>
expdp uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo08.dmp CONTENT=metadata_only
Data Options Demo DATA_OPTIONS=<
e
Directory Demo DIRECTORY=<directory_object>
e
Dumpfile Demo DUMPFILE=<file_name.dmp> -- can be used more than 1X at once
e

Encryption Demo
Default: The default mode depends on which other encryption-related parameters are used. If only the ENCRYPTION parameter is specified, then the default mode is TRANSPARENT.

If the ENCRYPTION_PASSWORD parameter is specified and the Oracle Encryption Wallet is open, then the default is DUAL. If the ENCRYPTION_PASSWORD parameter is specified and the Oracle Encryption Wallet is closed, then the default is PASSWORD.

ENCRYPTION_PASSWORD=<user_supplied_pwd>
expdp uwclass/uwclass DIRECTORY=data_pump_dir DUMPFILE=demo09.dmp ENCRYPTION=all ENCRYPTION_ALGORITHM=aes256 ENCRYPTION_MODE=dual ENCRYPTION_PASSWORD=a1pha
Estimate Demo ESTIMATE=<BLOCKS | STATISTICS>
impdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo10.dmp ESTIMATE=blocks

impdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo11.dmp ESTIMATE=statistics

Exclude Demos
EXCLUDE=<exclude_criterion>
-- exclude all (nonreferential) constraints, except for NOT NULL constraints and any constraints needed for successful table creation and loading
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo12.dmp EXCLUDE=constraint

-- exclude referential integrity (foreign key) constraints
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo13.dmp EXCLUDE=ref_constraint

-- exclude object grants on all object types and system priv grants
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo14.dmp EXCLUDE=grant

-- excludes the definitions of users
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo15.dmp EXCLUDE=user

-- excludes views
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo16.dmp EXCLUDE=view,package,function

To exclude a specific user and all objects of that user, specify a filter such as the following (where hr is the schema name of the user you want to exclude):
expdp uwclass/uwclass FULL=y DIRECTORY=data_pump_dir DUMPFILE=demo17.dmp EXCLUDE=SCHEMA:\"='HR'\"

Flashback SCN Demo
FLASHBACK_SCN=<scn_value>
conn / as sysdba

SELECT dbms_flashback.get_system_change_number FROM dual;

exit

expdp uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo18.dmp FLASHBACK_SCN=36477000

Flashback Time Demo
FLASHBACK_TIME=<timestamp_value>
conn / as sysdba

SELECT dbms_flashback.get_system_change_number
FROM dual;

SELECT SCN_TO_TIMESTAMP(dbms_flashback.get_system_change_number)
FROM dual;


exit

expdp uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo19.dmp FLASHBACK_TIME=\"TO_TIMESTAMP('01-SEP-2008 08:08:08', 'DD-MON-YYYY HH24:MI:SS')\"
Help Demo HELP=<Y | N>
impdp uwclass HELP=y
Include Demo INCLUDE=<include_list>
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo20.dmp INCLUDE=table

expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo21.dmp INCLUDE=\"IN ('SERVERS', 'SERV_INST')\"

expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo22.dmp INCLUDE=procedure

expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo23.dmp INCLUDE=INDEX:\"LIKE 'PK%\"
Job Name Demo JOB_NAME=<job_or_master_table_name>
expdp uwclass DIRECTORY=data_pump_dir DUMPFILE=demo24.dmp JOB_NAME=uwjob
Logfile Demo LOGFILE=<export.log | directory_object:file_name>
expdp uwclass/uwclass SCHEMAS=uwclass DUMPFILE=data_pump_dir:demo25.dmp LOGFILE=data_pump_dir:demo25.log
Network Link Demo NETWORK_LINK=<source_database_link>
expdp uwclass DIRECTORY=data_pump_dir DUMPFILE=demo26.dmp NETWORK_LINK=fixed_user
No Logfile Demo NOLOGFILE=<N | Y>
expdp uwclass TABLES=servers, airplanes DUMPFILE=data_pump_dir:demo27.dmp NOLOGFILE=y
Parallel Demo PARALLEL=<1 | parallel_degree>
expdp uwclass TABLES=servers DUMPFILE=data_pump_dir:demo28.dmp PARALLEL=2

Parfile Demo
PARFILE=<[directory_object.]file_name>
-- create this as a text file in the data_pump_dir directory
TABLES=servers DUMPFILE=data_pump_dir:demo29.dmp
LOGFILE=data_pump_dir:demo29.log
PARALLEL=2

expdp uwclass PARFILE=data_pump_dir:parfile.par

Partition Options Demo PARTITION_OPTIONS=<
expdp uwclass TABLES=airplanes DUMPFILE=data_pump_dir:demo30.dmp QUERY=airplanes:\"WHERE program_id = ''737''\"
Query Demo QUERY=<[schema.][table_name:]query_where_clause>
expdp uwclass TABLES=airplanes DUMPFILE=data_pump_dir:demo30.dmp QUERY=airplanes:\"WHERE program_id = ''737''\"
Remap Data Demo REMAP_DATA=<
expdp uwclass/uwclass TABLES=airplanes DUMPFILE=data_pump_dir:demo31.dmp SAMPLE=\"UWCLASS.AIRPLANES:10\"
Remap Datafile Demo REMAP_DATAFILE=<
expdp uwclass/uwclass TABLES=airplanes DUMPFILE=data_pump_dir:demo31.dmp SAMPLE=\"UWCLASS.AIRPLANES:10\"
Remap Schema Demo REMAP_SCHEMA=<
impdp uwclass DIRECTORY=data_pump_dir dumpfile=demo??.dmp schemas=abc  job_name=export_cw4ora REMAP_SCHEMA=abc:def  REMAP_TABLESPACE=users:uw_data REMAP_TABLESPACE=example:uwdata  exclude=GRANT
Remap Table Demo REMAP_TABLE=<
expdp uwclass/uwclass TABLES=airplanes DUMPFILE=data_pump_dir:demo31.dmp SAMPLE=\"UWCLASS.AIRPLANES:10\"
Remap Tablespace Demo REMAP_TABLESPACE=<
See Remap Schemas Demos
Skip Unusable Indexes Demo SKIP_UNUSABLE_INDEXES=<
expdp uwclass/uwclass TABLES=airplanes DUMPFILE=data_pump_dir:demo31.dmp SAMPLE=\"UWCLASS.AIRPLANES:10\"
SQL File Demo SQLFILE=<
expdp uwclass/uwclass TABLES=airplanes DUMPFILE=data_pump_dir:demo31.dmp SAMPLE=UWCLASS.AIRPLANES:10
Status Demo STATUS=<0 | seconds> -- how often job status is displayed
expdp uwclass/uwclass SCHEMAS=uwclass DUMPFILE=data_pump_dir:demo32.dmp STATUS=5
Streams Configuration Demo STREAMS_CONFIGURATION=<
See TRANSPORT_TABLESPACES Demo
Table Exists Action Demo TABLE_EXISTS_ACTION=<
See TRANSPORT_TABLESPACES Demo
Transform Demo TRANSPFORM=<
See TRANSPORT_TABLESPACES Demo
Transport Full Check Demo TRANSPORT_FULL_CHECK=<N | Y>
See TRANSPORT_TABLESPACES Demo
Version Demo VERSION=<COMPATIBLE | LATEST | version_string>
expdp uwclass/uwclass SCHEMAS=uwclass DUMPFILE=data_pump_dir:demo33.dmp VERSION=latest
 
Related Topics
DBMS_DATAPUMP
Export
Import
Transportable Tablespaces
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [289 users online]    © 2010 psoug.org