VIEW: SYS.DBA_XSTREAM_OUT_SUPPORT_MODE

Source

View Text - Preformatted

select owner, table_name, 'FULL' from "_DBA_XSTREAM_OUT_ALL_TABLES" where owner not in
    ('SYS', 'SYSTEM', 'CTXSYS', 'DBSNMP', 'LBACSYS', 'MDDATA', 'MDSYS',
     'DMSYS', 'OLAPSYS', 'ORDPLUGINS', 'ORDSYS', 'SI_INFORMTN_SCHEMA',
     'SYSMAN', 'OUTLN', 'EXFSYS', 'WMSYS', 'XDB', 'DVSYS', 'ORDDATA',
     'APEX_040200')
  MINUS (select owner, table_name, 'FULL' from  "_DBA_XSTREAM_UNSUPPORTED_12_1")
  UNION ALL
  select owner, table_name,
  (
    case
      /* For now, only queue tables have support mode 'NONE' */
      when ((t.table_name like 'AQ$_%') or
           (exists (select 1
                        from dba_queue_tables q
                        where q.owner = t.owner and
                              q.queue_table = t.table_name)))
        then 'NONE'
      /* Queue tables are unsupported, so exclude from 'ID KEY' query */
      when ((t.table_name not like 'AQ$_%') and
           (not exists (select 1
                        from dba_queue_tables q
                        where q.owner = t.owner and
                              q.queue_table = t.table_name)))
        then 'ID KEY'
    end
  )
  from "_DBA_XSTREAM_UNSUPPORTED_12_1" t

View Text - HTML Formatted

SELECT OWNER
, TABLE_NAME
, 'FULL'
FROM "_DBA_XSTREAM_OUT_ALL_TABLES"
WHERE OWNER NOT IN ('SYS'
, 'SYSTEM'
, 'CTXSYS'
, 'DBSNMP'
, 'LBACSYS'
, 'MDDATA'
, 'MDSYS'
, 'DMSYS'
, 'OLAPSYS'
, 'ORDPLUGINS'
, 'ORDSYS'
, 'SI_INFORMTN_SCHEMA'
, 'SYSMAN'
, 'OUTLN'
, 'EXFSYS'
, 'WMSYS'
, 'XDB'
, 'DVSYS'
, 'ORDDATA'
, 'APEX_040200') MINUS (SELECT OWNER
, TABLE_NAME
, 'FULL'
FROM "_DBA_XSTREAM_UNSUPPORTED_12_1") UNION ALL SELECT OWNER
, TABLE_NAME
, ( CASE /* FOR NOW
, ONLY QUEUE TABLES HAVE SUPPORT MODE 'NONE' */ WHEN ((T.TABLE_NAME LIKE 'AQ$_%') OR (EXISTS (SELECT 1
FROM DBA_QUEUE_TABLES Q
WHERE Q.OWNER = T.OWNER AND Q.QUEUE_TABLE = T.TABLE_NAME))) THEN 'NONE' /* QUEUE TABLES ARE UNSUPPORTED
, SO EXCLUDE
FROM 'ID KEY' QUERY */ WHEN ((T.TABLE_NAME NOT LIKE 'AQ$_%') AND (NOT EXISTS (SELECT 1
FROM DBA_QUEUE_TABLES Q
WHERE Q.OWNER = T.OWNER AND Q.QUEUE_TABLE = T.TABLE_NAME))) THEN 'ID KEY' END )
FROM "_DBA_XSTREAM_UNSUPPORTED_12_1" T