Database Reference
In-Depth Information
This issue is not limited to the
ALL_VIEWS
view; many views are affected:
EODA@ORA12CR1> select table_name, column_name
2 from dba_tab_columns
3 where data_type in ( 'LONG', 'LONG RAW' )
4 and owner = 'SYS'
5 and table_name like 'DBA%'
6 order by table_name;
TABLE_NAME COLUMN_NAME
------------------------------ ------------------------------
DBA_ADVISOR_SQLPLANS OTHER
DBA_ARGUMENTS DEFAULT_VALUE
DBA_CLUSTER_HASH_EXPRESSIONS HASH_EXPRESSION
DBA_CONSTRAINTS SEARCH_CONDITION
DBA_IND_EXPRESSIONS COLUMN_EXPRESSION
DBA_IND_PARTITIONS HIGH_VALUE
DBA_IND_SUBPARTITIONS HIGH_VALUE
DBA_MVIEWS QUERY
DBA_MVIEW_AGGREGATES MEASURE
DBA_MVIEW_ANALYSIS QUERY
DBA_NESTED_TABLE_COLS DATA_DEFAULT
DBA_OUTLINES SQL_TEXT
DBA_REGISTERED_MVIEWS QUERY_TXT
DBA_REGISTERED_SNAPSHOTS QUERY_TXT
DBA_SNAPSHOTS QUERY
DBA_SQLSET_PLANS OTHER
DBA_SQLTUNE_PLANS OTHER
DBA_SUBPARTITION_TEMPLATES HIGH_BOUND
DBA_SUMMARIES QUERY
DBA_SUMMARY_AGGREGATES MEASURE
DBA_TAB_COLS DATA_DEFAULT
DBA_TAB_COLS_V$ DATA_DEFAULT
DBA_TAB_COLUMNS DATA_DEFAULT
DBA_TAB_PARTITIONS HIGH_VALUE
DBA_TAB_SUBPARTITIONS HIGH_VALUE
DBA_TRIGGERS TRIGGER_BODY
DBA_VIEWS TEXT
DBA_VIEWS_AE TEXT
DBA_ZONEMAPS QUERY
DBA_ZONEMAP_MEASURES MEASURE
30 rows selected.
