Schemathings

An important step in creating a logical standby of your Oracle 10G database when using dataguard is to ensure that all the data is compatible.

These two queries will help you quickly spot what you need:

select distinct owner, table_name from dba_logstdby_unsupported order by owner, table_name;

select owner, table_name, bad_column from dba_logstdby_not_unique where table_name not in (select table_name from dba_logstdby_unsupported);