Database Administration (MOSC)

MOSC Banner

Does Supplemental Logging support LOB columns ?

edited Sep 14, 2014 5:00AM in Database Administration (MOSC) 4 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center