I've a bunch of tables that are setup for supplemental logging. Is there a way to get the ALTER TABLE ...ADD SUPPLEMENTAL LOG GROUP statements for all the tables.
That is from the result set of the SQL as below:
SELECT OWNER,TABLE_NAME,COLUMN_NAME,POSITION FROM DBA_LOG_GROUP_COLUMNS WHERE OWNER='PM' AND TABLE_NAME='PMS_RATE_PROF';
PM PMS_RATE_PROF PROFILE_ID 1
PM PMS_RATE_PROF SPID 2
PM PMS_RATE_PROF PROFILE_SET_SERIAL 3
PM PMS_RATE_PROF DAY_OF_WEEK 4
PM PMS_RATE_PROF SERVICE_RATE_ID 5
I should be able to generate the statement as below:
ALTER TABLE "PM"."PMS_RATE_PROF" ADD SUPPLEMENTAL LOG GROUP "PMS_RATE_PROF_SYNC" ("PROFILE_ID","DAY_OF_WEEK","SPID","SERVICE_RATE_ID","PROFILE_SET_SERIAL") ALWAYS;
Thank you!
-Bugs