Export
Parameters in Oracle DATAPUMP :
Parameter
|
Description
|
abort_step
|
Undocumented feature
|
access_method
|
Data Access Method – default is Automatic
|
attach
|
Attach to existing job – no default
|
cluster
|
Start workers across cluster; default is YES
|
compression
|
Content to export: default is METADATA_ONLY
|
content
|
Content to export: default is ALL
|
current_edition
|
Current edition: ORA$BASE is the default
|
data_options
|
Export data layer options
|
directory
|
Default directory specification
|
dumpfile
|
dumpfile names: format is (file1,…) default is expdat.dmp
|
encryption
|
Encryption type to be used: default varies
|
encryption_algorithm
|
Encryption algorithm to be used: default is AES128
|
encryption_mode
|
Encryption mode to be used: default varies
|
encryption_password
|
Encryption key to be used
|
estimate
|
Calculate size estimate: default is BLOCKS
|
estimate_only
|
Only estimate the length of the job: default is N
|
exclude
|
Export exclude option: no default
|
filesize
|
file size: the size of export dump files
|
flashback_time
|
database time to be used for flashback export: no
default
|
flashback_scn
|
system change number to be used for flashback export:
no default
|
full
|
indicates a full mode export
|
include
|
export include option: no default
|
ip_address
|
IP Address for PLSQL debugger
|
help
|
help: display description on export parameters, default
is N
|
job_name
|
Job Name: no default
|
keep_master
|
keep_master: Retain job table upon completion
|
log_entry
|
logentry
|
logfile
|
log export messages to specified file
|
metrics
|
Enable/disable object metrics reporting
|
mp_enable
|
Enable/disable multi-processing for current session
|
network_link
|
Network mode export
|
nologfile
|
No export log file created
|
package_load
|
Specify how to load PL/SQL objects
|
parallel
|
Degree of Parallelism: default is 1
|
parallel_threshold
|
Degree of DML Parallelism
|
parfile
|
parameter file: name of file that contains parameter
specifications
|
query
|
query used to select a subset of rows for a table
|
remap_data
|
Transform data in user tables
|
reuse_dumpfiles
|
reuse_dumpfiles: reuse existing dump files; default is
No
|
sample
|
Specify percentage of data to be sampled
|
schemas
|
schemas to export: format is ‘(schema1, .., schemaN)’
|
service_name
|
Service name that job will charge against
|
silent
|
silent: display information, default is NONE
|
status
|
Interval between status updates
|
tables
|
Tables to export: format is ‘(table1, table2, …,
tableN)’
|
tablespaces
|
tablespaces to transport/recover: format is
‘(ts1,…, tsN)’
|
trace
|
Trace option: enable sql_trace and timed_stat,
default is 0
|
transport_full_check
|
TTS perform test for objects in recovery set: default
is N
|
transportable
|
Use transportable data movement: default is NEVER
|
transport_tablespaces
|
Transportable tablespace option: default is N
|
tts_closure_check
|
Enable/disable transportable containment check: def is Y
|
userid
|
user/password to connect to oracle: no default
|
version
|
Job version: Compatible is the default
|
Do you like this post? Please share this article.
HTML Link Code:
Post a Comment