This content has been marked as final. Show 2 replies
Use ggsci "add trandata" instead of "alter table" to enable supplemental logging. The actual SQL can be traced if you want to know what it is, but it could change between releases. (You can script ggsci commands by piping commands through ggsci.)
As for the different logging levels in Oracle, across versions, etc, that isn't in the GG docs, but can be (should be, in any case) found in the database docs.
In GGSCI, you can also use the ADD SCHEMATRANDATA command which will automatically add supplemental logging for all tables in a schema. If you use GGSCI to ADD TRANDATA / SCHEMATRANDATA you can use the INFO TRANDATA command to determine if supplemental logging is enabled for a table.1 person found this helpful