O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required