1. Enable LogMiner
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
2. Enable Supplemental Logging
For 12c multitenant databases
ALTER SESSION SET CONTAINER=<pdb>;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER TABLE XW_IFP.UM_LOCAL_USER ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
3. Create a User Account
Oracle 12c multitenant databases
ALTER SESSION SET CONTAINER=cdb$root;
CREATE USER data_ext IDENTIFIED BY Ext_2017 CONTAINER=all;
GRANT create session, alter session, set container, select any dictionary, logmining, execute_catalog_role TO data_ext CONTAINER=all;
ALTER SESSION SET CONTAINER=<pdb>;
GRANT select on XW_IFP.UM_LOCAL_USER TO data_ext;
Oracle 12c standard databases
CREATE USER data_ext IDENTIFIED BY Ext_2017;
GRANT create session, alter session, select any dictionary, logmining, execute_catalog_role TO data_ext;
GRANT select on XW_IFP.UM_LOCAL_USER TO data_ext;
