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 |