Oracle Faq

—————-Script to Collect Data Guard Primary Site Diagnostic Information.txt———-
set echo off
set feedback off
column timecol new_value timestamp
column spool_extension new_value suffix
select to_char(sysdate,’Mondd_hhmi’) timecol,
‘.out’ spool_extension from sys.dual;
column output new_value dbname
select value || ‘_’ output
from v$parameter where name = ‘db_name’;
spool dg_prim_diag_&&dbname&×tamp&&suffix
set linesize 79
set pagesize 35
set trim on
set trims on
alter session set nls_date_format = ‘MON-DD-YYYY HH24:MI:SS’;
set feedback on
select to_char(sysdate) time […]

Hi ,
Prior to creating the Logical Standby please ensure the following:
1) Determine if the primary database contains datatypes or tables that are not
supported by a logical standby database.
SQL> select distinct owner,table_name from dba_logstdby_unsupported order by owner,table_name;
to view the column names and datatypes for one of the tables listed in previous query.
SQL> […]