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';

Friday, May 8, 2020

looks the overview db operations applied into a oracle database table

select * from ALL_TAB_MODIFICATIONS where table_name = 'REALTABLE_NAME'