Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Logging ALL Columns in a Table

user13179227Dec 16 2010
Hi I want to enable supplemental logging for all columns in table. So I issued the command
'ALTER TABLE xxxx ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS:


Now In that table I have 5 LOB colums,2 CLOBS and 2 Varchar2 columns and I dont want to log them but all the other columns.How to do this.Will logging all columns automatically reject LOBs and CLOBS???
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2011
Added on Dec 16 2010
#general-database-discussions
0 comments
536 views