Oracle Data Guard 11gR2 Administration : Beginner's Guide

Time for action – searching for and fixing any table row uniqueness problem

1. In order to check for any table row uniqueness, we can run the following query on the primary database:

   SQL> SELECT * FROM DBA_LOGSTDBY_NOT_UNIQUE;
   
   OWNER                          TABLE_NAME                     B
   ------------------------------ ------------------------------ -
   SCOTT                          BONUS                          N
   SCOTT                          SALGRADE                       N
   SH                             SALES                          N
   SH                             COSTS                          N
   SH                             SUPPLEMENTARY_DEMOGRAPHICS     N

   This query was run on a newly created 11g release 2 database, which only includes built-in example schemas. The output shows that several tables from SCOTT and SH schemas have row uniqueness problem.

   The BAD_COLUMN column has two values, which are Y and N. If you see the rows with BAD_COLUMN=Y, it means that the table column is defined using an unbounded data type, ...