system_versions

Creates, updates, deletes, gets or lists a system_versions resource.

Overview

Name	system_versions
Type	Resource
Id	oci.database.system_versions

Fields

The following fields are returned by SELECT queries:

list

The list of supported Exadata system versions for a given shape and GI version.

Name	Datatype	Description
giVersion	string	Grid Infrastructure version.
shape	string	Exadata shape.
systemVersions	array	Compatible Exadata system versions for a given shape and GI version.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	compartmentId, shape, giVersion, region	limit, page, sortOrder, opc-request-id	Gets a list of supported Exadata system versions for a given shape and GI version.

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).
giVersion	string	Specifies gi version query parameter.
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)
shape	string	Specifies shape query parameter.
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 Exadata system versions for a given shape and GI version.

SELECT
giVersion,
shape,
systemVersions
FROM oci.database.system_versions
WHERE compartmentId = '{{ compartmentId }}' -- required
AND shape = '{{ shape }}' -- required
AND giVersion = '{{ giVersion }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND sortOrder = '{{ sortOrder }}'
AND opc-request-id = '{{ opc-request-id }}'
;