Data Movement Utilities Guide and Reference

Exporting Large Objects (LOBs)

When exporting data from large object (LOB) columns, the default action is to select the first 32KB of data, and to place this data in the same file as the rest of the column data. If the lobsinfile modifier (see File Type Modifiers (Export)) has been specified, the export utility selects the entire LOB (up to 2GB), and places it in a separate file.
Note:The IXF file format does not store the LOB options of the column, such as whether or not the LOB column is logged. This means that the import utility cannot recreate a table containing a LOB column that is defined to be 1GB or larger.


[ Top of Page | Previous Page | Next Page ]