autonomous_db_versions

Creates, updates, deletes, gets or lists an autonomous_db_versions resource.

Overview

Name	autonomous_db_versions
Type	Resource
Id	oci.database.autonomous_db_versions

Fields

The following fields are returned by SELECT queries:

list

The supported Autonomous AI Database version.<br />

Name	Datatype	Description
dbWorkload	string	The Autonomous AI Database workload type. The following values are valid: - OLTP - indicates an Autonomous AI Transaction Processing database - DW - indicates an Autonomous AI Lakehouse database - AJD - indicates an Autonomous AI JSON Database - APEX - indicates an Autonomous AI Database with the Oracle APEX AI Application Development workload type. - LH - indicates an Oracle Autonomous AI Lakehouse database Note Starting December 2026, DW will not be supported as a valid value for this parameter. When creating an Autonomous AI Database, if this parameter is not specified, the default value is OLTP. This cannot be updated in parallel with any of the following: licenseModel, dbEdition, cpuCoreCount, computeCount, computeModel, adminPassword, whitelistedIps, isMTLSConnectionRequired, privateEndpointLabel, nsgIds, dbVersion, isRefreshable, dbName, scheduledOperations, dbToolsDetails, isLocalDataGuardEnabled, or isFreeTier. (OLTP, DW, AJD, APEX, LH)
details	string	A URL that points to a detailed description of the Autonomous AI Database version.
isDedicated	boolean	True if the database uses [dedicated Exadata infrastructure](https:​//docs.oracle.com/en/cloud/paas/autonomous-database/index.html).
isDefaultForFree	boolean	True if this version of the Oracle AI Database software's default is free.
isDefaultForPaid	boolean	True if this version of the Oracle AI Database software's default is paid.
isFreeTierEnabled	boolean	True if this version of the Oracle AI Database software can be used for Always-Free Autonomous AI Databases.
isPaidEnabled	boolean	True if this version of the Oracle AI Database software has payments enabled.
version	string	A valid Oracle AI Database version for Autonomous AI Database. When you specify 23ai for dbversion, the system will provision a 23ai database, but the UI will display it as 26ai. When you specify 26ai for dbversion, the system will provision and display a 26ai database as expected. For new databases, it is recommended to use either 19c or 26ai. Note Starting December 2026, 23ai will not be supported as a valid value for this parameter.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	compartmentId, region	limit, page, opc-request-id, dbWorkload, sortOrder	Gets a list of supported Autonomous AI Database versions.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
compartmentId	string	The compartment [OCID](/Content/General/Concepts/identifiers.htm).
region	string	OCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
dbWorkload	string	A filter to return only Autonomous AI Database resources that match the specified workload type.
limit	integer	The maximum number of items to return per page.
opc-request-id	string	Unique identifier for the request.
page	string	The pagination token to continue listing from.
sortOrder	string	The sort order to use, either ascending (ASC) or descending (DESC).

SELECT examples

list

Gets a list of supported Autonomous AI Database versions.

SELECT
dbWorkload,
details,
isDedicated,
isDefaultForFree,
isDefaultForPaid,
isFreeTierEnabled,
isPaidEnabled,
version
FROM oci.database.autonomous_db_versions
WHERE compartmentId = '{{ compartmentId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND opc-request-id = '{{ opc-request-id }}'
AND dbWorkload = '{{ dbWorkload }}'
AND sortOrder = '{{ sortOrder }}'
;