| 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.dmpFULL=y |
| Schema Export | SCHEMAS=<schema_name_list> |
| expdp uwclass DIRECTORY=data_pump_dir DUMPFILE=demo02.dmpSCHEMAS=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.dmpTABLESPACES=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.dmpATTACH=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.dmpENCRYPTION=all ENCRYPTION_ALGORITHM=aes256 ENCRYPTION_MODE=dualENCRYPTION_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 loadingexpdp 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_numberFROM 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.dmpJOB_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.dmpNETWORK_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.dmpPARALLEL=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.dmpQUERY=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.dmpREMAP_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.dmpREUSE_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.dmpFULL=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.dmpTABLESPACES=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.dmpATTACH=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.dmpENCRYPTION=all ENCRYPTION_ALGORITHM=aes256 ENCRYPTION_MODE=dualENCRYPTION_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 loadingexpdp 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_numberFROM 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.dmpJOB_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.dmpNETWORK_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.dmpPARALLEL=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.dmpQUERY=airplanes:\"WHERE program_id = ''737''\" |
| Query Demo | QUERY=<[schema.][table_name:]query_where_clause> |
| expdp uwclass TABLES=airplanes DUMPFILE=data_pump_dir:demo30.dmpQUERY=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 |
No comments:
Post a Comment