C
Changes to Static Data Dictionary Views

Oracle9i supports new static data dictionary views, and some static data dictionary views have been changed or have become obsolete in Oracle9i. This appendix lists the new, changed, and obsolete static data dictionary views in version 8 and Oracle9i.

This appendix covers the following topics:

Changes to Static Data Dictionary Views in Oracle9i
Changes to Static Data Dictionary Views in Version 8

See Also:
Oracle9i Database Reference for detailed information about the static data dictionary views in Oracle9i, and for descriptions of the columns in these views.

Changes to Static Data Dictionary Views in Oracle9i

The following sections list the new, changed, and obsolete static data dictionary views in Oracle9i:

Static Data Dictionary Views Added in Oracle9i

The static data dictionary views listed in this section are new in Oracle9i.

Static Data Dictionary Views Added in Release 9.0.1

The following static data dictionary views were added in release 9.0.1:

`ALL_AUDIT_POLICIES`	`ALL_BASE_TABLE_MVIEWS`
`ALL_EXTERNAL_LOCATIONS`	`ALL_EXTERNAL_TABLES`
`ALL_INDEXTYPE_COMMENTS`	`ALL_JOIN_IND_COLUMNS`
`ALL_LOG_GROUP_COLUMNS`	`ALL_LOG_GROUPS`
`ALL_MVIEW_LOGS`	`ALL_OPERATOR_COMMENTS`
`ALL_PENDING_CONV_TABLES`	`ALL_POLICY_CONTEXTS`
`ALL_POLICY_GROUPS`	`ALL_PROCEDURES`
`ALL_SECONDARY_OBJECTS`	`ALL_SOURCE_TAB_COLUMNS`
`ALL_SOURCE_TABLES`	`ALL_SQLJ_TYPE_ATTRS`
`ALL_SQLJ_TYPE_METHODS`	`ALL_SQLJ_TYPES`
`ALL_STORED_SETTINGS`	`ALL_SUBSCRIBED_COLUMNS`
`ALL_SUBSCRIBED_TABLES`	`ALL_SUBSCRIPTIONS`
`ALL_TYPE_VERSIONS`	`DBA_APPLICATION_ROLES`
`DBA_ATTRIBUTE_TRANSFORMATIONS`	`DBA_AUDIT_POLICIES`
`DBA_BASE_TABLE_MVIEWS`	`DBA_EXTERNAL_LOCATIONS`
`DBA_EXTERNAL_TABLES`	`DBA_FGA_AUDIT_TRAIL`
`DBA_GLOBAL_CONTEXT`	`DBA_INDEXTYPE_COMMENTS`
`DBA_JOIN_IND_COLUMNS`	`DBA_LOG_GROUP_COLUMNS`
`DBA_LOG_GROUPS`	`DBA_MVIEW_LOGS`
`DBA_OPERATOR_COMMENTS`	`DBA_PENDING_CONV_TABLES`
`DBA_POLICY_CONTEXTS`	`DBA_POLICY_GROUPS`
`DBA_PROCEDURES`	`DBA_PROXIES`
`DBA_REPCAT_EXCEPTIONS`	`DBA_REPEXTENSIONS`
`DBA_REPSITES_NEW`	`DBA_RESUMABLE`
`DBA_SECONDARY_OBJECTS`	`DBA_SNAPSHOT_LOG_FILTER_COLS`
`DBA_SOURCE_TAB_COLUMNS`	`DBA_SOURCE_TABLES`
`DBA_SQLJ_TYPE_ATTRS`	`DBA_SQLJ_TYPE_METHODS`
`DBA_SQLJ_TYPES`	`DBA_STORED_SETTINGS`
`DBA_SUBSCRIBED_COLUMNS`	`DBA_SUBSCRIBED_TABLES`
`DBA_SUBSCRIPTIONS`	`DBA_TEMPLATE_REFGROUPS`
`DBA_TEMPLATE_TARGETS`	`DBA_TRANSFORMATIONS`
`DBA_TYPE_VERSIONS`	`DBA_UNDO_EXTENTS`
`USER_APPLICATION_ROLES`	`USER_ATTRIBUTE_TRANSFORMATIONS`
`USER_AUDIT_POLICIES`	`USER_BASE_TABLE_MVIEWS`
`USER_EXTERNAL_LOCATIONS`	`USER_EXTERNAL_TABLES`
`USER_INDEXTYPE_COMMENTS`	`USER_JOIN_IND_COLUMNS`
`USER_LOG_GROUP_COLUMNS`	`USER_LOG_GROUPS`
`USER_MVIEW_LOGS`	`USER_OPERATOR_COMMENTS`
`USER_PENDING_CONV_TABLES`	`USER_POLICY_CONTEXTS`
`USER_POLICY_GROUPS`	`USER_PROCEDURES`
`USER_PROXIES`	`USER_RESUMABLE`
`USER_SECONDARY_OBJECTS`	`USER_SOURCE_TAB_COLUMNS`
`USER_SOURCE_TABLES`	`USER_SQLJ_TYPE_ATTRS`
`USER_SQLJ_TYPE_METHODS`	`USER_SQLJ_TYPES`
`USER_STORED_SETTINGS`	`USER_SUBSCRIBED_COLUMNS`
`USER_SUBSCRIBED_TABLES`	`USER_SUBSCRIPTIONS`
`USER_TRANSFORMATIONS`	`USER_TYPE_VERSIONS`

Static Data Dictionary Views Renamed in Oracle9i

The static data dictionary views listed in this section have been renamed in Oracle9i. If an application requires one or more of the views listed below, then modify the application accordingly.

Static Data Dictionary Views Renamed in Release 9.0.1

The following static data dictionary views were renamed in release 9.0.1:

Note:

The old names are maintained for backward compatibility with version 8. Oracle Corporation recommends migrating to the new names.

Table C-1 Static Data Dictionary Views Renamed in Release 9.0.1

Pre-Release 9.0.1 Name	Release 9.0.1 Name
`ALL_REGISTERED_SNAPSHOTS`	`ALL_REGISTERED_MVIEWS`
`ALL_SNAPSHOT_REFRESH_TIMES`	`ALL_MVIEW_REFRESH_TIMES`
`DBA_REGISTERED_SNAPSHOT_GROUPS`	`DBA_REGISTERED_MVIEW_GROUPS`
`DBA_REGISTERED_SNAPSHOTS`	`DBA_REGISTERED_MVIEWS`
`DBA_SNAPSHOT_LOG_FILTER_COLS`	`DBA_MVIEW_LOG_FILTER_COLS`
`DBA_SNAPSHOT_REFRESH_TIMES`	`DBA_MVIEW_REFRESH_TIMES`
`USER_SNAPSHOT_REFRESH_TIMES`	`USER_MVIEW_REFRESH_TIMES`
`USER_REGISTERED_SNAPSHOTS`	`USER_REGISTERED_MVIEWS`

Static Data Dictionary Views with Added Columns in Oracle9i

New columns were added to the static data dictionary views listed in the following sections.

See Also:

Oracle9i Database Reference for detailed information about these views

Static Data Dictionary Views with Added Columns in Release 9.0.1

New columns were added to the following static data dictionary views in release 9.0.1:

`ALL_ALL_TABLES`	`ALL_ARGUMENTS`
`ALL_ASSOCIATIONS`	`ALL_CLUSTERS`
`ALL_CONSTRAINTS`	`ALL_DIMENSIONS`
`ALL_IND_COLUMNS`	`ALL_IND_PARTITIONS`
`ALL_INDEXES`	`ALL_INDEXTYPE_OPERATORS`
`ALL_INDEXTYPES`	`ALL_MVIEWS`
`ALL_OBJECT_TABLES`	`ALL_OPBINDINGS`
`ALL_OUTLINES`	`ALL_PART_INDEXES`
`ALL_POLICIES`	`ALL_REPCAT_TEMPLATE_OBJECTS`
`ALL_REPCAT_TEMPLATE_SITES`	`ALL_REPCOLUMN`
`ALL_REPDDL`	`ALL_REPFLAVOR_COLUMNS`
`ALL_REPOBJECT`	`ALL_SNAPSHOT_LOGS`
`ALL_SUMDELTA`	`ALL_TAB_COLUMNS`
`ALL_TAB_PRIVS`	`ALL_TAB_PRIVS_MADE`
`ALL_TAB_PRIVS_RECD`	`ALL_TABLES`
`ALL_TYPE_ATTRS`	`ALL_TYPE_METHODS`
`ALL_TYPES`	`ALL_USTATS`
`ALL_VIEWS`	`CLU`
`COLS`	`DBA_ALL_TABLES`
`DBA_ASSOCIATIONS`	`DBA_AUDIT_EXISTS`
`DBA_AUDIT_OBJECT`	`DBA_AUDIT_SESSION`
`DBA_AUDIT_STATEMENT`	`DBA_AUDIT_TRAIL`
`DBA_CLUSTERS`	`DBA_CONSTRAINTS`
`DBA_CONTEXT`	`DBA_IND_COLUMNS`
`DBA_IND_PARTITIONS`	`DBA_INDEXES`
`DBA_INDEXTYPE_OPERATORS`	`DBA_INDEXTYPES`
`DBA_MVIEWS`	`DBA_OBJECT_TABLES`
`DBA_OPBINDINGS`	`DBA_OUTLINES`
`DBA_PART_INDEXES`	`DBA_POLICIES`
`DBA_REPCAT_TEMPLATE_OBJECTS`	`DBA_REPCAT_TEMPLATE_SITES`
`DBA_REPCOLUMN`	`DBA_REPDDL`
`DBA_REPFLAVOR_COLUMNS`	`DBA_REPOBJECT`
`DBA_RSRC_PLANS`	`DBA_SNAPSHOT_LOGS`
`DBA_TAB_COLUMNS`	`DBA_TAB_PRIVS`
`DBA_TABLES`	`DBA_TABLESPACES`
`DBA_TYPE_ATTRS`	`DBA_TYPE_METHODS`
`DBA_TYPES`	`DBA_USTATS`
`DBA_VIEWS`	`IND`
`TABS`	`USER_ALL_TABLES`
`USER_ARGUMENTS`	`USER_ASSOCIATIONS`
`USER_AUDIT_OBJECT`	`USER_AUDIT_SESSION`
`USER_AUDIT_STATEMENT`	`USER_AUDIT_TRAIL`
`USER_CLUSTERS`	`USER_CONSTRAINTS`
`USER_DIMENSIONS`	`USER_IND_COLUMNS`
`USER_IND_PARTITIONS`	`USER_INDEXES`
`USER_INDEXTYPE_OPERATORS`	`USER_INDEXTYPES`
`USER_MVIEWS`	`USER_OBJECT_TABLES`
`USER_OPBINDINGS`	`USER_OUTLINES`
`USER_PART_INDEXES`	`USER_POLICIES`
`USER_REPCAT_TEMPLATE_OBJECTS`	`USER_REPCAT_TEMPLATE_SITES`
`USER_REPCOLUMN`	`USER_REPDDL`
`USER_REPFLAVOR_COLUMNS`	`USER_REPOBJECT`
`USER_REPPARAMETER_COLUMN`	`USER_SNAPSHOT_LOGS`
`USER_TAB_COLUMNS`	`USER_TAB_PRIVS`
`USER_TAB_PRIVS_MADE`	`USER_TAB_PRIVS_RECD`
`USER_TABLES`	`USER_TABLESPACES`
`USER_TYPE_ATTRS`	`USER_TYPE_METHODS`
`USER_TYPES`	`USER_USTATS`
`USER_VIEWS`

Changes to Static Data Dictionary Views in Version 8

The following sections list the new, changed, and obsolete static data dictionary views in version 8:

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_MVIEWS`
`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_DMT_FREE_SPACE`	`DBA_DMT_USED_EXTENTS`
`DBA_IND_EXPRESSIONS`	`DBA_IND_SUBPARTITIONS`
`DBA_INDEXTYPE_OPERATORS`	`DBA_INDEXTYPES`
`DBA_INTERNAL_TRIGGERS`	`DBA_LMT_FREE_SPACE`
`DBA_LMT_USED_EXTENTS`	`DBA_LOB_PARTITIONS`
`DBA_LOB_SUBPARTITIONS`	`DBA_MVIEW_AGGREGATES`
`DBA_MVIEW_ANALYSIS`	`DBA_MVIEW_DETAIL_RELATIONS`
`DBA_MVIEW_JOINS`	`DBA_MVIEW_KEYS`
`DBA_MVIEWS`	`DBA_OPANCILLARY`
`DBA_OPARGUMENTS`	`DBA_OPBINDINGS`
`DBA_OPERATORS`	`DBA_OUTLINE_HINTS`
`DBA_OUTLINES`	`DBA_PART_LOBS`
`DBA_POLICIES`	`DBA_REPCAT_REFRESH_TEMPLATES`
`DBA_REPCAT_TEMPLATE_OBJECTS`	`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_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`
`DBMS_ALERT_INFO`	`DBMS_LOCK_ALLOCATED`
`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_MVIEWS`	`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.

See Also:

Oracle9i Database Reference for detailed information about these views

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_TAB_COLUMNS`
`ALL_TABLES`	`ALL_UPDATABLE_COLUMNS`
`ALL_VIEWS`	`COL`
`DBA_CLUSTERS`	`DBA_CONSTRAINTS`
`DBA_DATA_FILES`	`DBA_DEPENDENCIES`
`DBA_EXTENTS`	`DBA_FREE_SPACE`
`DBA_INDEXES`	`DBA_OBJ_AUDIT_OPTS`
`DBA_OBJECTS`	`DBA_PROFILES`
`DBA_REFRESH`	`DBA_REFRESH_CHILDREN`
`DBA_REPOBJECT`	`DBA_REPPRIORITY`
`DBA_RGROUP`	`DBA_ROLLBACK_SEGS`
`DBA_SEGMENTS`	`DBA_SNAPSHOT_LOGS`
`DBA_SNAPSHOTS`	`DBA_TAB_COLUMNS`
`DBA_TABLES`	`DBA_TABLESPACES`
`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_OBJ_AUDIT_OPTS`
`USER_OBJECTS`	`USER_REFRESH`
`USER_REFRESH_CHILDREN`	`USER_REPOBJECT`
`USER_REPPRIORITY`	`USER_REPSCHEMA`
`USER_REPSITES`	`USER_SEGMENTS`
`USER_SNAPSHOT_LOGS`	`USER_SNAPSHOTS`
`USER_TAB_COLUMNS`	`USER_TABLES`
`USER_TABLESPACES`	`USER_UPDATABLE_COLUMNS`
`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_ARGUMENTS`
`ALL_CLUSTERS`	`ALL_COLL_TYPES`
`ALL_CONSTRAINTS`	`ALL_IND_COLUMNS`
`ALL_IND_PARTITIONS`	`ALL_IND_SUBPARTITIONS`
`ALL_INDEXES`	`ALL_MVIEW_ANALYSIS`
`ALL_NESTED_TABLES`	`ALL_OBJECT_TABLES`
`ALL_OBJECTS`	`ALL_PART_COL_STATISTICS`
`ALL_PART_HISTOGRAMS`	`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_SUBPART_HISTOGRAMS`
`ALL_TAB_COL_STATISTICS`	`ALL_TAB_COLUMNS`
`ALL_TAB_HISTOGRAMS`	`ALL_TAB_PARTITIONS`
`ALL_TABLES`	`ALL_TRIGGERS`
`DBA_ALL_TABLES`	`DBA_CLUSTERS`
`DBA_COLL_TYPES`	`DBA_CONSTRAINTS`
`DBA_CONTEXT`	`DBA_DATA_FILES`
`DBA_IND_COLUMNS`	`DBA_IND_PARTITIONS`
`DBA_IND_SUBPARTITIONS`	`DBA_INDEXES`
`DBA_JOBS`	`DBA_JOBS_RUNNING`
`DBA_MVIEW_ANALYSIS`	`DBA_NESTED_TABLES`
`DBA_OBJECT_TABLES`	`DBA_OBJECTS`
`DBA_OUTLINE_HINTS`	`DBA_PART_COL_STATISTICS`
`DBA_PART_HISTOGRAMS`	`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_SUBPART_HISTOGRAMS`
`DBA_TAB_COL_STATISTICS`	`DBA_TAB_COLUMNS`
`DBA_TAB_HISTOGRAMS`	`DBA_TAB_PARTITIONS`
`DBA_TABLES`	`DBA_TABLESPACES`
`DBA_TRIGGERS`	`DBA_USERS`
`INDEX_STATS`	`REPCAT_REPCAT`
`REPCAT_REPOBJECTS`	`USER_ALL_TABLES`
`USER_ARGUMENTS`	`USER_CLUSTERS`
`USER_COLL_TYPES`	`USER_CONSTRAINTS`
`USER_IND_COLUMNS`	`USER_IND_PARTITIONS`
`USER_IND_SUBPARTITIONS`	`USER_INDEXES`
`USER_JOBS`	`USER_MVIEW_ANALYSIS`
`USER_NESTED_TABLES`	`USER_OBJECT_TABLES`
`USER_OBJECTS`	`USER_OUTLINE_HINTS`
`USER_PART_COL_STATISTICS`	`USER_PART_HISTOGRAMS`
`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_SUBPART_HISTOGRAMS`	`USER_TAB_COL_STATISTICS`
`USER_TAB_COLUMNS`	`USER_TAB_HISTOGRAMS`
`USER_TAB_PARTITIONS`	`USER_TABLES`
`USER_TABLESPACES`	`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, then modify the application accordingly.

Static Data Dictionary Views with Dropped Columns in Release 8.0

The columns listed in Table C-2 were dropped in release 8.0.

Table C-2 Static Data Dictionary Views with Dropped Columns in Release 8.0

Static Data Dictionary Views	Dropped Columns
`DEFCALLDEST`	`DEFERRED_TRAN_DB`
`DEFERROR`	`DEFERRED_TRAN_DB` `ERROR_TIME`
`DEFTRAN`	`COMMIT_COMMENT` `DEFERRED_TRAN_DB` `DESTINATION_LIST` `ORIGIN_TRAN_DB` `ORIGIN_TRAN_ID` `ORIGIN_USER`
`DEFTRANDEST`	`DEFERRED_TRAN_DB`

Static Data Dictionary Views with Dropped Columns in Release 8.1

The columns listed in Table C-3 were dropped in release 8.1.

Table C-3 Static Data Dictionary Views with Dropped Columns in Release 8.1

Static Data Dictionary Views Dropped Columns

Static Data Dictionary Views	Dropped Columns
`DBA_AUDIT_OBJECT` `USER_AUDIT_OBJECT`	`OBJECT_LABEL` `SESSION_LABEL`
`DBA_AUDIT_SESSION` `USER_AUDIT_SESSION`	`SESSION_LABEL`
`DBA_AUDIT_STATEMENT` `USER_AUDIT_STATEMENT`	`SESSION_LABEL`
`DBA_AUDIT_TRAIL` `USER_AUDIT_TRAIL`	`OBJECT_LABEL` `SESSION_LABEL`
`DBA_CONTEXT`	`ATTRIBUTE`
`ALL_IND_COLUMNS` `DBA_IND_COLUMNS` `USER_IND_COLUMNS`	`COLUMN_EXPRESSION`
`ALL_JOBS` `DBA_JOBS` `USER_JOBS`	`CLEARANCE_HI` `CLEARANCE_LO` `CURRENT_SESSION_LABEL`
`ALL_REFS` `DBA_REFS` `USER_REFS`	`HAS_REFERENTIAL_CONS` `REFERENTIAL_CONS_NAME`

DBA_AUDIT_OBJECT

USER_AUDIT_OBJECT

OBJECT_LABEL

SESSION_LABEL

DBA_AUDIT_SESSION

USER_AUDIT_SESSION

SESSION_LABEL

DBA_AUDIT_STATEMENT

USER_AUDIT_STATEMENT

SESSION_LABEL

DBA_AUDIT_TRAIL

USER_AUDIT_TRAIL

OBJECT_LABEL

SESSION_LABEL

DBA_CONTEXT

ATTRIBUTE

ALL_IND_COLUMNS

DBA_IND_COLUMNS

USER_IND_COLUMNS

COLUMN_EXPRESSION

ALL_JOBS

DBA_JOBS

USER_JOBS

CLEARANCE_HI

CLEARANCE_LO

CURRENT_SESSION_LABEL

ALL_REFS

DBA_REFS

USER_REFS

HAS_REFERENTIAL_CONS

REFERENTIAL_CONS_NAME

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, then modify the application accordingly.

Static Data Dictionary Views with Renamed Columns in Release 8.0

The columns listed in Table C-4 were renamed in release 8.0.

Table C-4 Static Data Dictionary Views with Renamed Columns in Release 8.0

Static Data Dictionary View	Oracle7 Column Name	Release 8.0 Column Name
`DBA_RCHILD`	`TYPE`	`TYPE#`
`DEFSCHEDULE`	`LAST_ERROR`	`LAST_ERROR_NUMBER`
`DEFSCHEDULE`	`LAST_MSG`	`LAST_ERROR_MESSAGE`

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-5 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, then modify the application accordingly.

Table C-5 Columns That May Return Nulls in Release 8.1

Static Data Dictionary Views	Columns	Explanation
`DBA_DATA_FILES`	`AUTOEXTENSIBLE` `BLOCKS` `BYTES` `INCREMENT_BY` `MAXBLOCKS` `MAXBYTES`	These columns return a null if the data file is offline and therefore not readable.
`ALL_IND_COLUMNS` `DBA_IND_COLUMNS` `USER_IND_COLUMNS`	`COLUMN_NAME`	This column returns a null if an index is on a function instead of a column. In this case, there is no column to list.
`ALL_IND_PARTITIONS` `DBA_IND_PARTITIONS` `USER_IND_PARTITIONS`	`INITIAL_EXTENT` `MAX_EXTENT` `MIN_EXTENT` `NEXT_EXTENT` `PCT_INCREASE`	These columns return a null if the index is partitioned using a composite method and no default value was specified for the partition.
`ALL_OBJECT_TABLES` `DBA_OBJECT_TABLES` `USER_OBJECT_TABLES`	`TABLESPACE_NAME`	This column returns a null in if an object table is partitioned or if it is a temporary table.
`ALL_SEGMENTS` `DBA_SEGMENTS` `USER_SEGMENTS`	`BLOCKS` `BYTES` `EXTENTS` `NEXT_EXTENT` `PCT_INCREASE`	The `BLOCKS`, `BYTES`, and `EXTENTS` columns return a null if the segment header cannot be read because the file is offline or if there is some other corruption. The `NEXT_EXTENT` and `PCT_INCREASE` columns return a null if the tablespace storing the segment is locally managed and uses the `AUTOALLOCATE` option, because the system chooses the extent sizes, and the algorithm cannot be explained in terms of `NEXT_EXTENT` and `PCT_INCREASE`.
`ALL_TAB_PARTITIONS` `DBA_TAB_PARTITIONS` `USER_TAB_PARTITIONS`	`INITIAL_EXTENT` `MAX_EXTENT` `MIN_EXTENT` `NEXT_EXTENT` `PCT_INCREASE`	These columns return a null if the table is partitioned using a composite method and no default value was specified for the partition.
`ALL_TABLESPACES` `DBA_TABLESPACES` `USER_TABLESPACES`	`NEXT_EXTENT` `PCT_INCREASE`	These columns return a null if the tablespace is locally managed and uses the `AUTOALLOCATE` option, because the system chooses the extent sizes, and the algorithm cannot be explained in terms of `NEXT_EXTENT` and `PCT_INCREASE`.
`ALL_TRIGGERS` `DBA_TRIGGERS` `USER_TRIGGERS`	`TABLE_NAME`	This column returns a null if the trigger is a system trigger. In this case, the base object type of the trigger will be `SCHEMA` or `DATABASE`, instead of `TABLE` or `VIEW`.

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 views became obsolete in release 8.1 and are not available in release 8.1 and higher:

ALL_LABELS

C Changes to Static Data Dictionary Views

Changes to Static Data Dictionary Views in Oracle9i

Static Data Dictionary Views Added in Oracle9i

Static Data Dictionary Views Added in Release 9.0.1

Static Data Dictionary Views Renamed in Oracle9i

Static Data Dictionary Views Renamed in Release 9.0.1

Table C-1 Static Data Dictionary Views Renamed in Release 9.0.1

Static Data Dictionary Views with Added Columns in Oracle9i

Static Data Dictionary Views with Added Columns in Release 9.0.1

Changes to Static Data Dictionary Views in Version 8

Static Data Dictionary Views Added in Version 8

Static Data Dictionary Views Added in Release 8.0

Static Data Dictionary Views Added in Release 8.1

Static Data Dictionary Views with Added Columns in Version 8

Static Data Dictionary Views with Added Columns in Release 8.0

Static Data Dictionary Views with Added Columns in Release 8.1

Static Data Dictionary Views with Dropped Columns in Version 8

Static Data Dictionary Views with Dropped Columns in Release 8.0

Table C-2 Static Data Dictionary Views with Dropped Columns in Release 8.0

Static Data Dictionary Views with Dropped Columns in Release 8.1

Table C-3 Static Data Dictionary Views with Dropped Columns in Release 8.1

Static Data Dictionary Views with Renamed Columns in Version 8

Static Data Dictionary Views with Renamed Columns in Release 8.0

Table C-4 Static Data Dictionary Views with Renamed Columns in Release 8.0

Static Data Dictionary Views with Columns That May Return Nulls

Table C-5 Columns That May Return Nulls in Release 8.1

Static Data Dictionary Views Obsolete in Version 8

Static Data Dictionary Views Obsolete in Release 8.0

Static Data Dictionary Views Obsolete in Release 8.1

C
Changes to Static Data Dictionary Views