Database Utilities
ContentsOpens a new window
Opens a new window
Page 808 of 1018

SecureFiles LOB Considerations

SecureFiles LOBs are supported when database compatibility is set to 11.2 or later. Only SQL_REDO columns can be filled in for SecureFiles LOB columns; SQL_UNDO columns are not filled in.

Transparent Data Encryption (TDE) and data compression can be enabled on SecureFiles LOB columns at the primary database.

Deduplication of SecureFiles LOB columns is fully supported. Fragment operations are not supported.

If LogMiner encounters redo generated by unsupported operations, then it generates rows with the OPERATION column set to UNSUPPORTED. No SQL_REDO or SQL_UNDO will be generated for these redo records.

Previous PageOpens a new window
Page 808 of 1018
Next PageOpens a new window