Showing posts with label oracle. Show all posts
Showing posts with label oracle. Show all posts

Thursday, May 28, 2020

how to check if oracle goldengate trandata is enabled for a specific table

select * from DBA_LOG_GROUPS where TABLE_NAME='XXX';

select * from ALL_LOG_GROUPS where TABLE_NAME='XXX';

select * from USER_LOG_GROUPS where TABLE_NAME='XXX';