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
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
Static Data Dictionary Views with Added Columns in Oracle9i
New columns were added to the static data dictionary views listed in the following sections.
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.
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 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 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 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 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: