1 Changes in This Release for Oracle Database Reference
This chapter lists the following changes in Oracle Database Reference for Oracle Database 23ai:
1.1 New Features
-
The maximum number of columns allowed in a database table or view has been increased from 1000 to 4096.
See: MAX_COLUMNS
-
The following initialization parameters are new in Oracle Database 23ai:
-
The following static data dictionary views are new in Oracle Database 23ai:
-
ALL_ANNOTATION_VALUES, DBA_ANNOTATION_VALUES, and USER_ANNOTATION_VALUES
-
ALL_ANNOTATIONS_USAGE, DBA_ANNOTATIONS_USAGE, and USER_ANNOTATIONS_USAGE
-
ALL_BLOCKCHAIN_ROW_VERSION_COLS, DBA_BLOCKCHAIN_ROW_VERSION_COLS, and USER_BLOCKCHAIN_ROW_VERSION_COLS
-
ALL_BLOCKCHAIN_ROW_VERSION_HISTORY, DBA_BLOCKCHAIN_ROW_VERSION_HISTORY, and USER_BLOCKCHAIN_ROW_VERSION_HISTORY
-
ALL_BLOCKCHAIN_TABLE_CHAINS, DBA_BLOCKCHAIN_TABLE_CHAINS, and USER_BLOCKCHAIN_TABLE_CHAINS
-
ALL_BLOCKCHAIN_TABLE_EPOCHS, DBA_BLOCKCHAIN_TABLE_EPOCHS, and USER_BLOCKCHAIN_TABLE_EPOCHS
-
ALL_BLOCKCHAIN_TABLE_HASH_COL_ORDER, DBA_BLOCKCHAIN_TABLE_HASH_COL_ORDER, and USER_BLOCKCHAIN_TABLE_HASH_COL_ORDER
-
ALL_DOMAIN_CONSTRAINTS, DBA_DOMAIN_CONSTRAINTS, and USER_DOMAIN_CONSTRAINTS
-
ALL_IMMUTABLE_ROW_VERSION_COLS, DBA_IMMUTABLE_ROW_VERSION_COLS, and USER_IMMUTABLE_ROW_VERSION_COLS
-
ALL_IMMUTABLE_ROW_VERSION_HISTORY, DBA_IMMUTABLE_ROW_VERSION_HISTORY, and USER_IMMUTABLE_ROW_VERSION_HISTORY
-
ALL_IMMUTABLE_TABLE_COLUMNS, DBA_IMMUTABLE_TABLE_COLUMNS, and USER_IMMUTABLE_TABLE_COLUMNS
-
ALL_IMMUTABLE_TABLE_EPOCHS, DBA_IMMUTABLE_TABLE_EPOCHS, and USER_IMMUTABLE_TABLE_EPOCHS
-
ALL_INCOMPLETE_SAGAS, DBA_INCOMPLETE_SAGAS, and USER_INCOMPLETE_SAGAS
-
ALL_JSON_COLLECTION_TABLES, DBA_JSON_COLLECTION_TABLES, and USER_JSON_COLLECTION_TABLES
-
ALL_JSON_COLLECTIONS, DBA_JSON_COLLECTIONS, and USER_JSON_COLLECTIONS
-
ALL_JSON_DOMAIN_SCHEMA_COLUMNS, DBA_JSON_DOMAIN_SCHEMA_COLUMNS, and USER_JSON_DOMAIN_SCHEMA_COLUMNS
-
ALL_JSON_DUALITY_VIEW_LINKS, DBA_JSON_DUALITY_VIEW_LINKS, and USER_JSON_DUALITY_VIEW_LINKS
-
ALL_JSON_DUALITY_VIEW_TAB_COLS, DBA_JSON_DUALITY_VIEW_TAB_COLS, and USER_JSON_DUALITY_VIEW_TAB_COLS
-
ALL_JSON_DUALITY_VIEW_TABS, DBA_JSON_DUALITY_VIEW_TABS, and USER_JSON_DUALITY_VIEW_TABS
-
ALL_JSON_DUALITY_VIEWS, DBA_JSON_DUALITY_VIEWS, and USER_JSON_DUALITY_VIEWS
-
ALL_JSON_SCHEMA_COLUMNS, DBA_JSON_SCHEMA_COLUMNS, and USER_JSON_SCHEMA_COLUMNS
-
ALL_MLE_ENV_IMPORTS, DBA_MLE_ENV_IMPORTS, and USER_MLE_ENV_IMPORTS
-
ALL_MLE_PROCEDURES, DBA_MLE_PROCEDURES, and USER_MLE_PROCEDURES
-
ALL_MVIEW_DETAIL_LOGICAL_PARTITION, DBA_MVIEW_DETAIL_LOGICAL_PARTITION, and USER_MVIEW_DETAIL_LOGICAL_PARTITION
-
ALL_PG_EDGE_RELATIONSHIPS, DBA_PG_EDGE_RELATIONSHIPS, and USER_PG_EDGE_RELATIONSHIPS
-
ALL_PG_ELEMENT_LABELS, DBA_PG_ELEMENT_LABELS, and USER_PG_ELEMENT_LABELS
-
ALL_PG_LABEL_PROPERTIES, DBA_PG_LABEL_PROPERTIES, and USER_PG_LABEL_PROPERTIES
-
ALL_PG_PROP_DEFINITIONS, DBA_PG_PROP_DEFINITIONS, and USER_PG_PROP_DEFINITIONS
-
ALL_PROPERTY_GRAPHS, DBA_PROPERTY_GRAPHS, and USER_PROPERTY_GRAPHS
-
ALL_SAGA_FINALIZATION, DBA_SAGA_FINALIZATION, and USER_SAGA_FINALIZATION
-
ALL_SAGA_PARTICIPANT_SET, DBA_SAGA_PARTICIPANT_SET, and USER_SAGA_PARTICIPANT_SET
-
ALL_SAGA_PARTICIPANTS, DBA_SAGA_PARTICIPANTS, and USER_SAGA_PARTICIPANTS
-
ALL_SAGAS, DBA_SAGAS, and USER_SAGAS
-
DBA_SCHEMA_PRIVS, ROLE_SCHEMA_PRIVS, SESSION_SCHEMA_PRIVS, and USER_SCHEMA_PRIVS
-
DBA_SYS_PRIVS_ALL, ROLE_SYS_PRIVS_ALL, SESSION_PRIVS_ALL, and USER_SYS_PRIVS_ALL
-
ALL_TABLE_ACCESS_STATS, DBA_TABLE_ACCESS_STATS, and USER_TABLE_ACCESS_STATS
-
ALL_TABLE_VIRTUAL_COLUMNS, DBA_TABLE_VIRTUAL_COLUMNS, and USER_TABLE_VIRTUAL_COLUMNS
-
ALL_TXEVENTQ_MIGRATION_STATUS, DBA_TXEVENTQ_MIGRATION_STATUS and USER_TXEVENTQ_MIGRATION_STATUS
-
The following tables are new in Oracle Database 23ai:
-
The following dynamic performance views are new in Oracle Database 23ai:
See Also:
Oracle Database New Features for a complete list of new features for this release
1.2 Deprecated Features
The following features are deprecated in Oracle Database 23ai, and may be desupported in a future release:
Initialization parameters:
Static data dictionary views:
Dynamic performance views:
See Also:
Oracle Database Upgrade Guide for a complete list of deprecated features for this release
1.3 Desupported Features
The following features are desupported in Oracle Database 23ai:
-
The
OPTIMIZER_SECURE_VIEW_MERGING
initialization parameter -
The
V$EMX_USAGE_STATS
view
See Also:
Oracle Database Upgrade Guide for a complete list of desupported features for this release