Oracle Data Pump, Export, and Import
- The Data Pump Import DATA_OPTIONS parameter has a new CONTINUE_LOAD_ON_FORMAT_ERROR option. If Data Pump encounters a stream format error when loading table data, Data Pump attempts to skip forward to find the start of the next row and continue loading that data from that location.
- For security purposes, Data Pump handles fixed user database links with passwords differently.
- Starting with Oracle Database 18c, you can include the unified audit trail in either full or partial export and import operations using Oracle Data Pump.
- As of Oracle Database 18c, XML_CLOB option of the Export DATA_OPTIONS parameter is desupported.
Default: There is no default. If this parameter is not used, then the special data handling options it provides simply do not take effect.
The DATA_OPTIONS parameter designates how certain types of data should be handled during export operations.
Syntax and Description
DATA_OPTIONS= [GROUP_PARTITION_TABLE_DATA | VERIFY_STREAM_FORMAT]
GROUP_PARTITION_TABLE_DATA — tells Data Pump to unload all table data in one operation rather than unload each table partition as a separate operation. As a result, the definition of the table will not matter at import time because Import will see one partition of data that will be loaded into the entire table.
VERIFY_STREAM_FORMAT — validates the format of a data stream before it is written to the Data Pump dump file. The verification checks for a valid format for the stream after it is generated but before it is written to disk. This assures that there are no errors when the dump file is created, which in turn helps to assure that there will not be errors when the stream is read at import time.
The Export DATA_OPTIONS parameter requires the job version to be set to 11.0.0 or later
This example shows an export operation in which data for all partitions of a table are unloaded together instead of the default behavior of unloading the data for each partition separately.
expdp hr TABLES=hr.sales DIRECTORY=tstdir DUMPFILE=hr.dmp VERSION=11.2 GROUP_PARTITION_TABLE_DATA
Stay tuned for More articles on Oracle 18c
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp