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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

supplemental logging

User347578Sep 21 2014 — edited Sep 22 2014

Hello All,

I've an enabled  supplemental logging on an oracle 10g 10.2.0.4 database .

example :  alter table  USER.ABTL_CONTACT ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

             owner                                    constraint_name                 C         Table_Name                                                       Status                    Validated

             USER                                  SYS_C00310877                  ?        ABTL_CONTACT                                                  DISABLED             NOT VALIDATED

Now my question is  when we enable supplemental logging is there any constraint created like "SYS_C00310877 "  which shows in  user_constraints view .

If yes will it be in disabled and non validate state ?

Any expert suggestion is highly appreciated..

Thanks in Advance

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 20 2014
Added on Sep 21 2014
#general-database-discussions
13 comments
2,826 views