Does Supplemental Logging support LOB columns ?
From oracle's document we know that All columns are supported by supplemental logging with the exception of:
LONG
LOB
LONG RAW
Abstract Data Types
Collections
For LOB , I do the following test and it seems supplemental logging does work for lobs.
drop table lobt1;
create table lobt1 (id number,col1 clob) lob(col1) store as basicfile lob_lobt1 (tablespace ts_info_ind_01 pctversion 10);
select owner,pctversion,retention_type from dba_lobs where table_name='LOBT1';
OWNER PCTVERSION RETENTI
------------------------------ ---------- -------
SCOTT 10 NO
insert into lobt1 values(9,'ZZZ') ;
commit;
select versions_xid from lobt1 VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE;