Default: There is no default. If this parameter is not used, then the special data handling options it provides simply do not take effect.
Purpose
The DATA_OPTIONS
parameter designates how certain types of data should be handled during export operations.
Syntax and Description
DATA_OPTIONS=XML_CLOBS
The XML_CLOBS
option specifies that XMLType
columns are to be exported in uncompressed CLOB
format regardless of the XMLType
storage format that was defined for them.
XMLType
stored as CLOB
is deprecated as of Oracle Database 12c Release 1 (12.1). XMLType
tables and columns are now stored as binary XML.
If a table has XMLType
columns stored only in CLOB
format, then it is not necessary to specify the XML_CLOBS
option because Data Pump automatically exports them in CLOB
format.If a table has XMLType
columns stored as any combination of object-relational (schema-based), binary, or CLOB
formats, then Data Pump exports them in compressed format, by default. This is the preferred method. However, if you need to export the data in uncompressed CLOB
format, you can use the XML_CLOBS
option to override the default.
Restrictions
Using the XML_CLOBS
option requires that the same XML schema be used at both export and import time.
The Export DATA_OPTIONS
parameter requires the job version to be set to 11.0.0
or later. See "VERSION".
Example
This example shows an export operation in which any XMLType
columns in the hr.xdb_tab1
table are exported in uncompressed CLOB
format regardless of the XMLType
storage format that was defined for them.
> expdp hr TABLES=hr.xdb_tab1 DIRECTORY=dpump_dir1 DUMPFILE=hr_xml.dmp VERSION=11.2 DATA_OPTIONS=XML_CLOBS
Oracle XML DB Developer's Guide for information specific to exporting and importing XMLType
tables