Replicat abending with database error 1403

Replicat abending with database error 1403() during the initial startup during a compressed update. This error can be seen very frequently on a production environment when implementing Goldengate for the first time. During the instantiation of the target database, if there is any open transaction which is yet to be committed, the extract is started…

SQLcl to view DDL

Today I ran into a scenario where I need to check if a table had an UNIQUE index. Instead of writing a quick sql I decided to try the new (not so new) SQLcl tool.  With the new describe (info), I could get a quick snapshot of the table DDL, Indexes and constraints. Pretty cool.  

Oracle Default Users

‘ANONYMOUS’ — HTTP access to XDB ‘APPQOSSYS’ — QOS system user ‘AUDSYS’ — audit super user ‘BI’ — Business Intelligence ‘CTXSYS’ — Text ‘DBSNMP’ — SNMP agent for OEM ‘DIP’ — Directory Integration Platform ‘DMSYS’ — Data Mining ‘DVF’ — Database Vault ‘DVSYS’ — Database Vault ‘EXDSYS’ — External ODCI System User ‘EXFSYS’ — Expression…

Script to add trandata for GoldenGate

Here is a simple script to check which tables are missing trandata and generate the GG (so call DDL) to enable it on them. select ‘add trandata ‘||t.owner||’.’||t.table_name stmt from (select owner, table_name from dba_tables) t, (select owner, table_name from dba_log_groups) s where t.owner = s.owner (+) and t.table_name = s.table_name (+) and s.table_name is…