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

• Static Data Dictionary Views with Added Columns in Version 8

• Static Data Dictionary Views with Dropped Columns in Version 8

• Static Data Dictionary Views with Renamed Columns in Version 8

• Static Data Dictionary Views with Columns That May Return Nulls

• Static Data Dictionary Views Obsolete in Version 8

  See Also: Oracle8i Reference for descriptions of the new and changed views listed in this appendix, and for descriptions of the columns in these views.

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 Added in Release 8.1.6

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

ALL_MVIEWS	DBA_MVIEWS
USER_MVIEW

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: Oracle8i 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_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 Added Columns in Release 8.1.6

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

ALL_ARGUMENTS	ALL_PART_HISTOGRAMS
ALL_SUBPART_HISTOGRAMS	ALL_TAB_HISTOGRAMS
DBA_PART_HISTOGRAMS	DBA_SUBPART_HISTOGRAMS
DBA_TAB_HISTOGRAMS	USER_ARGUMENTS
USER_PART_HISTOGRAMS	USER_SUBPART_HISTOGRAMS
USER_TAB_HISTOGRAMS

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 Table C-1 were dropped in release 8.0.

Table C-1 Static Data Dictionary View 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 Table C-2 were dropped in release 8.1.

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

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

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 Table C-3 were renamed in release 8.0.

Table C-3 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
	LAST_MSG	LAST_ERROR_MESSAGE

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

Table C-4 Columns That May Return Nulls in Release 8.1 (Page 1 of 2)

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

ALL_LABELS