User Tools

Site Tools


datapump

Data Pump

Fully Transportable Export

TRANSPORTABLE = ALWAYS
VERSION = 12
FULL = Y

Disable Logging

TRANSFORM = DISABLE_ARCHIVE_LOGGING:Y

Exporting Views as Tables

VIEWS_AS_TABLES = <VIEW_NAME>:<TABLE_NAME>

Compressing Data During an Import

TRANSFORM = TABLE_COMPRESSION_CLAUSE:<NONE,COMPRESS,NOCOMPRESS>

Create SecureFile LOBs During an Import

TRANSFORM = LOB_STORAGE:<SECUREFILE,BASICFILE,DEFAULT,NO_CHANGE>

Time Stamps in Log File Output

LOGTIME = <NONE,STATUS,LOGFILE,ALL>

datapump.txt · Last modified: 2021/12/06 11:30 by 127.0.0.1