autonomous_db_preview_versions

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

Overview

Name	autonomous_db_preview_versions
Type	Resource
Id	oci.database.autonomous_db_preview_versions

Fields

The following fields are returned by SELECT queries:

list

The Autonomous AI Database preview version. Note that preview version software is only available for [Autonomous AI Database Serverless instances](https:​//docs.oracle.com/en/cloud/paas/autonomous-database/serverless/).<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 preview version.
timePreviewBegin	string (date-time)	The date and time when the preview version availability begins.
timePreviewEnd	string (date-time)	The date and time when the preview version availability ends.
version	string	A valid Autonomous AI Database preview version.

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, sortBy, sortOrder	Gets a list of supported Autonomous AI Database versions. Note that preview version software is only available for<br />Autonomous AI Database Serverless (https:​//docs.oracle.com/en/cloud/paas/autonomous-database/index.html) databases.<br />

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)
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.
sortBy	string	The field to sort by. You can provide one sort order (sortOrder). Default order for DBWORKLOAD is ascending. Note: If you do not include the availability domain filter, the resources are grouped by availability domain, then sorted.
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. Note that preview version software is only available for<br />Autonomous AI Database Serverless (https:​//docs.oracle.com/en/cloud/paas/autonomous-database/index.html) databases.<br />

SELECT
dbWorkload,
details,
timePreviewBegin,
timePreviewEnd,
version
FROM oci.database.autonomous_db_preview_versions
WHERE compartmentId = '{{ compartmentId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND opc-request-id = '{{ opc-request-id }}'
AND sortBy = '{{ sortBy }}'
AND sortOrder = '{{ sortOrder }}'
;