select owner, table_name from dba_logstdby_unsupported_table 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')
SELECT OWNER
, TABLE_NAME
FROM DBA_LOGSTDBY_UNSUPPORTED_TABLE
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')
|
|
|