C
Changes to Static Data Dictionary Views
Version 8 supports new static data dictionary views, and some static data dictionary views have been changed or have become obsolete in version 8. This appendix lists the new, changed, and obsolete static data dictionary views in version 8.
This appendix covers the following topics:
Static Data Dictionary Views Added in Version 8
The static data dictionary views listed in this section are new in version 8.
Static Data Dictionary Views Added in Release 8.0
The following static data dictionary views were added in release 8.0:
|
ALL_ALL_TABLES |
ALL_COLL_TYPES |
|
ALL_DIRECTORIES |
ALL_IND_PARTITIONS |
|
ALL_LIBRARIES |
ALL_LOBS |
|
ALL_METHOD_PARAMS |
ALL_METHOD_RESULTS |
|
ALL_NESTED_TABLES |
ALL_OBJECT_TABLES |
|
ALL_OBJECTS |
ALL_PART_COL_STATISTICS |
|
ALL_PART_HISTOGRAMS |
ALL_PART_INDEXES |
|
ALL_PART_KEY_COLUMNS |
ALL_PART_TABLES |
|
ALL_PROBE_OBJECTS |
ALL_REFS |
|
ALL_REGISTERED_SNAPSHOTS |
ALL_REPCOLUMN |
|
ALL_REPGENOBJECTS |
ALL_SNAPSHOT_LOGS |
|
ALL_SNAPSHOT_REFRESH_TIMES |
ALL_TAB_COL_STATISTICS |
|
ALL_TAB_HISTOGRAMS |
ALL_TAB_PARTITIONS |
|
ALL_TYPE_ATTRS |
ALL_TYPE_METHODS |
|
ALL_TYPES |
DBA_ALL_TABLES |
|
DBA_COLL_TYPES |
DBA_DIRECTORIES |
|
DBA_IND_PARTITIONS |
DBA_LIBRARIES |
|
DBA_LOBS |
DBA_METHOD_PARAMS |
|
DBA_METHOD_RESULTS |
DBA_NESTED_TABLES |
|
DBA_OBJECT_TABLES |
DBA_PART_COL_STATISTICS |
|
DBA_PART_HISTOGRAMS |
DBA_PART_INDEXES |
|
DBA_PART_KEY_COLUMNS |
DBA_PART_TABLES |
|
DBA_PENDING_TRANSACTIONS |
DBA_QUEUE_SCHEDULES |
|
DBA_QUEUE_TABLES |
DBA_QUEUES |
|
DBA_REFS |
DBA_REGISTERED_SNAPSHOT_GROUPS |
|
DBA_REGISTERED_SNAPSHOTS |
DBA_REPCOLUMN |
|
DBA_REPGENOBJECTS |
DBA_SNAPSHOT_LOG_FILTER_COLS |
|
DBA_SNAPSHOT_REFRESH_TIMES |
DBA_TAB_COL_STATISTICS |
|
DBA_TAB_HISTOGRAMS |
DBA_TAB_PARTITIONS |
|
DBA_TYPE_ATTRS |
DBA_TYPE_METHODS |
|
DBA_TYPES |
DEFLOB |
|
DEFPROPAGATOR |
FILEXT$ |
|
HS_ALL_CAPS |
HS_ALL_DD |
|
HS_ALL_INITS |
HS_BASE_CAPS |
|
HS_BASE_DD |
HS_CLASS_CAPS |
|
HS_CLASS_DD |
HS_CLASS_INIT |
|
HS_EXTERNAL_OBJECT_PRIVILEGES |
HS_EXTERNAL_OBJECTS |
|
HS_EXTERNAL_USER_PRIVILEGES |
HS_FDS_CLASS |
|
HS_FDS_INST |
HS_INST_CAPS |
|
HS_INST_DD |
HS_INST_INIT |
|
TRUSTED_SERVERS |
TS_PITR_CHECK |
|
TS_PITR_OBJECTS_TO_BE_DROPPED |
USER_ALL_TABLES |
|
USER_COLL_TYPES |
USER_IND_PARTITIONS |
|
USER_LIBRARIES |
USER_LOBS |
|
USER_METHOD_PARAMS |
USER_METHOD_RESULTS |
|
USER_NESTED_TABLES |
USER_OBJECT_TABLES |
|
USER_PART_COL_STATISTICS |
USER_PART_HISTOGRAMS |
|
USER_PART_INDEXES |
USER_PART_KEY_COLUMNS |
|
USER_PART_TABLES |
USER_PASSWORD_LIMITS |
|
USER_QUEUE_TABLES |
USER_QUEUES |
|
USER_REFS |
USER_REGISTERED_SNAPSHOTS |
|
USER_REPCOLUMN |
USER_REPGENOBJECTS |
|
USER_SNAPSHOT_REFRESH_TIMES |
USER_TAB_COL_STATISTICS |
|
USER_TAB_HISTOGRAMS |
USER_TAB_PARTITIONS |
|
USER_TYPE_ATTRS |
USER_TYPE_METHODS |
|
USER_TYPES |
|
Static Data Dictionary Views Added in Release 8.1
The following static data dictionary views were added in release 8.1:
|
ALL_ASSOCIATIONS |
ALL_CONTEXT |
|
ALL_DIM_ATTRIBUTES |
ALL_DIM_CHILD_OF |
|
ALL_DIM_HIERARCHIES |
ALL_DIM_JOIN_KEY |
|
ALL_DIM_LEVEL_KEY |
ALL_DIM_LEVELS |
|
ALL_DIMENSIONS |
ALL_IND_EXPRESSIONS |
|
ALL_IND_SUBPARTITIONS |
ALL_INDEXTYPE_OPERATORS |
|
ALL_INDEXTYPES |
ALL_INTERNAL_TRIGGERS |
|
ALL_LOB_PARTITIONS |
ALL_LOB_SUBPARTITIONS |
|
ALL_MVIEW_AGGREGATES |
ALL_MVIEW_ANALYSIS |
|
ALL_MVIEW_DETAIL_RELATIONS |
ALL_MVIEW_JOINS |
|
ALL_MVIEW_KEYS |
ALL_OPANCILLARY |
|
ALL_OPARGUMENTS |
ALL_OPBINDINGS |
|
ALL_OPERATORS |
ALL_PART_LOBS |
|
ALL_PARTIAL_DROP_TABS |
ALL_POLICIES |
|
ALL_QUEUE_TABLES |
ALL_QUEUES |
|
ALL_REFRESH_DEPENDENCIES |
ALL_REPCAT_REFRESH_TEMPLATES |
|
ALL_REPCAT_TEMPLATE_OBJECTS |
ALL_REPCAT_TEMPLATE_PARMS |
|
ALL_REPCAT_TEMPLATE_SITES |
ALL_REPCAT_USER_AUTHORIZATIONS |
|
ALL_REPCAT_USER_PARM_VALUES |
ALL_SUBPART_COL_STATISTICS |
|
ALL_SUBPART_HISTOGRAMS |
ALL_SUBPART_KEY_COLUMNS |
|
ALL_SUMDELTA |
ALL_SUMMARIES |
|
ALL_SUMMARY_AGGREGATES |
ALL_SUMMARY_DETAIL_TABLES |
|
ALL_SUMMARY_JOINS |
ALL_SUMMARY_KEYS |
|
ALL_TAB_MODIFICATIONS |
ALL_TAB_SUBPARTITIONS |
|
ALL_UNUSED_COL_TABS |
ALL_USTATS |
|
ALL_VARRAYS |
DATABASE_COMPATIBLE_LEVEL |
|
DBA_ASSOCIATIONS |
DBA_CONTEXT |
|
DBA_DIM_ATTRIBUTES |
DBA_DIM_CHILD_OF |
|
DBA_DIM_HIERARCHIES |
DBA_DIM_JOIN_KEY |
|
DBA_DIM_LEVEL_KEY |
DBA_DIM_LEVELS |
|
DBA_DIMENSIONS |
DBA_IND_EXPRESSIONS |
|
DBA_IND_SUBPARTITIONS |
DBA_INDEXTYPE_OPERATORS |
|
DBA_INDEXTYPES |
DBA_INTERNAL_TRIGGERS |
|
DBA_LOB_PARTITIONS |
DBA_LOB_SUBPARTITIONS |
|
DBA_MVIEW_AGGREGATES |
DBA_MVIEW_ANALYSIS |
|
DBA_MVIEW_DETAIL_RELATIONS |
DBA_MVIEW_JOINS |
|
DBA_MVIEW_KEYS |
DBA_OPANCILLARY |
|
DBA_OPARGUMENTS |
DBA_OPBINDINGS |
|
DBA_OPERATORS |
DBA_OUTLINE_HINTS |
|
DBA_OUTLINES |
DBA_PART_LOBS |
|
DBA_PARTIAL_DROP_TABS |
DBA_POLICIES |
|
DBA_REPCAT_REFRESH_TEMPLATES |
DBA_REPCAT_TEMPLATE_OBJECTS |
|
DBA_REPCAT_TEMPLATE_PARMS |
DBA_REPCAT_TEMPLATE_SITES |
|
DBA_REPCAT_USER_AUTHORIZATIONS |
DBA_REPCAT_USER_PARM_VALUES |
|
DBA_RSRC_CONSUMER_GROUP_PRIVS |
DBA_RSRC_CONSUMER_GROUPS |
|
DBA_RSRC_MANAGER_SYSTEM_PRIVS |
DBA_RSRC_PLAN_DIRECTIVES |
|
DBA_RSRC_PLANS |
DBA_RULESETS |
|
DBA_SUBPART_COL_STATISTICS |
DBA_SUBPART_HISTOGRAMS |
|
DBA_SUBPART_KEY_COLUMNS |
DBA_SUMMARIES |
|
DBA_SUMMARY_DETAIL_TABLES |
DBA_TAB_MODIFICATIONS |
|
DBA_TAB_SUBPARTITIONS |
DBA_TEMP_FILES |
|
DBA_UNUSED_COL_TABS |
DBA_USTATS |
|
DBA_VARRAYS |
PLUGGABLE_SET_CHECK |
|
PROXY_USERS |
QUEUE_PRIVILEGES |
|
SESSION_CONTEXT |
STRADDLING_TS_OBJECTS |
|
UNI_PLUGGABLE_SET_CHECK |
USER_ASSOCIATIONS |
|
USER_DIM_ATTRIBUTES |
USER_DIM_CHILD_OF |
|
USER_DIM_HIERARCHIES |
USER_DIM_JOIN_KEY |
|
USER_DIM_LEVEL_KEY |
USER_DIM_LEVELS |
|
USER_DIMENSIONS |
USER_IND_EXPRESSIONS |
|
USER_IND_SUBPARTITIONS |
USER_INDEXTYPE_OPERATORS |
|
USER_INDEXTYPES |
USER_INTERNAL_TRIGGERS |
|
USER_LOB_PARTITIONS |
USER_LOB_SUBPARTITIONS |
|
USER_MVIEW_AGGREGATES |
USER_MVIEW_ANALYSIS |
|
USER_MVIEW_DETAIL_RELATIONS |
USER_MVIEW_JOINS |
|
USER_MVIEW_KEYS |
USER_OPANCILLARY |
|
USER_OPARGUMENTS |
USER_OPBINDINGS |
|
USER_OPERATORS |
USER_OUTLINE_HINTS |
|
USER_OUTLINES |
USER_PART_LOBS |
|
USER_PARTIAL_DROP_TABS |
USER_POLICIES |
|
USER_QUEUE_SCHEDULES |
USER_REPCAT_REFRESH_TEMPLATES |
|
USER_REPCAT_TEMPLATE_OBJECTS |
USER_REPCAT_TEMPLATE_PARMS |
|
USER_REPCAT_TEMPLATE_SITES |
USER_REPCAT_USER_AUTHORIZATION |
|
USER_REPCAT_USER_PARM_VALUES |
USER_RSRC_CONSUMER_GROUP_PRIVS |
|
USER_RSRC_MANAGER_SYSTEM_PRIVS |
USER_RULESETS |
|
USER_SUBPART_COL_STATISTICS |
USER_SUBPART_HISTOGRAMS |
|
USER_SUBPART_KEY_COLUMNS |
USER_SUMMARIES |
|
USER_SUMMARY_DETAIL_TABLES |
USER_TAB_MODIFICATIONS |
|
USER_TAB_SUBPARTITIONS |
USER_UNUSED_COL_TABS |
|
USER_USTATS |
USER_VARRAYS |
Static Data Dictionary Views with Added Columns in Version 8
New columns were added to the static data dictionary views listed in the following sections.
Static Data Dictionary Views with Added Columns in Release 8.0
New columns were added to the following static data dictionary views in release 8.0:
|
ALL_ARGUMENTS |
ALL_CLUSTERS |
|
ALL_CONSTRAINTS |
ALL_DEPENDENCIES |
|
ALL_INDEXES |
ALL_OBJECTS |
|
ALL_REFRESH |
ALL_REFRESH_CHILDREN |
|
ALL_REPOBJECT |
ALL_REPPRIORITY |
|
ALL_REPSCHEMA |
ALL_REPSITES |
|
ALL_SNAPSHOTS |
ALL_TABLES |
|
ALL_TAB_COLUMNS |
ALL_UPDATABLE_COLUMNS |
|
ALL_VIEWS |
COL |
|
DBA_CLUSTERS |
DBA_CONSTRAINTS |
|
DBA_DATA_FILES |
DBA_DEPENDENCIES |
|
DBA_EXTENTS |
DBA_FREE_SPACE |
|
DBA_INDEXES |
DBA_OBJECTS |
|
DBA_OBJ_AUDIT_OPTS |
DBA_PROFILES |
|
DBA_REFRESH |
DBA_REFRESH_CHILDREN |
|
DBA_REPOBJECT |
DBA_REPPRIORITY |
|
DBA_RGROUP |
DBA_ROLLBACK_SEGS |
|
DBA_SEGMENTS |
DBA_SNAPSHOTS |
|
DBA_SNAPSHOT_LOGS |
DBA_TABLES |
|
DBA_TABLESPACES |
DBA_TAB_COLUMNS |
|
DBA_UPDATABLE_COLUMNS |
DBA_USERS |
|
DBA_VIEWS |
DEFERROR |
|
DEFTRANDEST |
FILE_PING |
|
INDEX_STATS |
SYS_OBJECTS |
|
USER_ARGUMENTS |
USER_CLUSTERS |
|
USER_CONSTRAINTS |
USER_DEPENDENCIES |
|
USER_EXTENTS |
USER_FREE_SPACE |
|
USER_INDEXES |
USER_OBJECTS |
|
USER_OBJ_AUDIT_OPTS |
USER_REFRESH |
|
USER_REFRESH_CHILDREN |
USER_REPOBJECT |
|
USER_REPPRIORITY |
USER_REPSCHEMA |
|
USER_REPSITES |
USER_SEGMENTS |
|
USER_SNAPSHOTS |
USER_SNAPSHOT_LOGS |
|
USER_TAB_COLUMNS |
USER_UPDATABLE_COLUMNS |
|
USER_TABLES |
USER_TABLESPACES |
|
USER_USERS |
USER_VIEWS |
Static Data Dictionary Views with Added Columns in Release 8.1
New columns were added to the following static data dictionary views in release 8.1:
|
ALL_ALL_TABLES |
ALL_CLUSTERS |
|
ALL_COLL_TYPES |
ALL_CONSTRAINTS |
|
ALL_IND_PARTITIONS |
ALL_NESTED_TABLES |
|
ALL_INDEXES |
ALL_IND_COLUMNS |
|
ALL_IND_PARTITIONS |
ALL_IND_SUBPARTITIONS |
|
ALL_MVIEW_ANALYSIS |
ALL_OBJECTS |
|
ALL_OBJECT_TABLES |
ALL_PART_COL_STATISTICS |
|
ALL_PART_INDEXES |
ALL_PART_TABLES |
|
ALL_PROBE_OBJECTS |
ALL_REFS |
|
ALL_REPCAT |
ALL_REPCAT_TEMPLATE_SITES |
|
ALL_REPCOLUMN |
ALL_REPGROUP |
|
ALL_REPOBJECT |
ALL_SNAPSHOTS |
|
ALL_TAB_COL_STATISTICS |
ALL_TAB_PARTITIONS |
|
ALL_TABLES |
ALL_TAB_COLUMNS |
|
ALL_TRIGGERS |
DBA_ALL_TABLES |
|
DBA_CLUSTERS |
DBA_COLL_TYPES |
|
DBA_CONSTRAINTS |
DBA_CONTEXT |
|
DBA_DATA_FILES |
DBA_IND_PARTITIONS |
|
DBA_JOBS |
DBA_INDEXES |
|
DBA_IND_COLUMNS |
DBA_IND_PARTITIONS |
|
DBA_IND_SUBPARTITIONS |
DBA_JOBS_RUNNING |
|
DBA_MVIEW_ANALYSIS |
DBA_NESTED_TABLES |
|
DBA_OBJECTS |
DBA_OBJECT_TABLES |
|
DBA_OUTLINE_HINTS |
DBA_PART_COL_STATISTICS |
|
DBA_PART_INDEXES |
DBA_PART_TABLES |
|
DBA_PRIV_AUDIT_OPTS |
DBA_QUEUE_SCHEDULES |
|
DBA_QUEUE_TABLES |
DBA_REFS |
|
DBA_REGISTERED_SNAPSHOT_GROUPS |
DBA_REPCAT |
|
DBA_REPCAT_TEMPLATE_SITES |
DBA_REPCOLUMN |
|
DBA_REPGROUP |
DBA_REPOBJECT |
|
DBA_SNAPSHOTS |
DBA_STMT_AUDIT_OPTS |
|
DBA_TAB_COLUMNS |
DBA_TAB_COL_STATISTICS |
|
DBA_TAB_PARTITIONS |
DBA_TRIGGERS |
|
DBA_TABLES |
DBA_TABLESPACES |
|
DBA_USERS |
INDEX_STATS |
|
REPCAT_REPCAT |
REPCAT_REPOBJECTS |
|
USER_ALL_TABLES |
USER_CLUSTERS |
|
USER_COLL_TYPES |
USER_CONSTRAINTS |
|
USER_IND_PARTITIONS |
USER_IND_SUBPARTITIONS |
|
USER_JOBS |
USER_INDEXES |
|
USER_IND_COLUMNS |
USER_MVIEW_ANALYSIS |
|
USER_NESTED_TABLES |
USER_OBJECTS |
|
USER_OBJECT_TABLES |
USER_OUTLINE_HINTS |
|
USER_PART_COL_STATISTICS |
USER_PART_INDEXES |
|
USER_PART_TABLES |
USER_QUEUE_TABLES |
|
USER_REFS |
USER_REPCAT |
|
USER_REPCAT_TEMPLATE_SITES |
USER_REPCOLUMN |
|
USER_REPGROUP |
USER_REPOBJECT |
|
USER_SNAPSHOTS |
USER_TABLES |
|
USER_TAB_COL_STATISTICS |
USER_TAB_PARTITIONS |
|
USER_TABLESPACES |
USER_TAB_COLUMNS |
|
USER_TRIGGERS |
USER_USERS |
Static Data Dictionary Views with Dropped Columns in Version 8
The columns listed in the following sections were dropped in version 8. If an application requires one or more of the columns listed below, modify the application accordingly.
Static Data Dictionary Views with Dropped Columns in Release 8.0
The columns listed Table C-1 were dropped in release 8.0.
Static Data Dictionary Views with Dropped Columns in Release 8.1
The columns listed Table C-2 were dropped in release 8.1.
Static Data Dictionary Views with Renamed Columns in Version 8
The columns listed in the following sections were renamed in version 8. If an application requires one or more of the columns listed below, modify the application accordingly.
Static Data Dictionary Views with Renamed Columns in Release 8.0
The columns listed Table C-3 were renamed in release 8.0.
Note:
There are no static data dictionary views with renamed columns in release 8.1.
|
Static Data Dictionary Views with Columns That May Return Nulls
Starting with release 8.1, the columns in the static data dictionary views listed in Table C-4 may return nulls; in previous releases, these columns could not return nulls. If an application requires non-null values for one or more of the columns listed below, modify the application accordingly.
Static Data Dictionary Views Obsolete in Version 8
The static data dictionary views in this section are obsolete in version 8.
Static Data Dictionary Views Obsolete in Release 8.0
The following static data dictionary views became obsolete in release 8.0 and are not available in release 8.0 and higher:
|
ALL_HISTOGRAMS |
DBA_HISTOGRAMS |
|
DEFCALL |
USER_HISTOGRAMS |
Static Data Dictionary Views Obsolete in Release 8.1
The following static data dictionary view became obsolete in release 8.1 and is not available in release 8.1 and higher:
