Skip to main content

autonomous_database_software_images

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

Overview​

Nameautonomous_database_software_images
TypeResource
Idoci.database.autonomous_database_software_images

Fields​

The following fields are returned by SELECT queries:

The Autonomous AI Database Software Image.

NameDatatypeDescription
idstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the Autonomous AI Database Software Image.
autonomousDsiOneOffPatchesarrayOne-off patches included in the Autonomous AI Database Software Image
compartmentIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the compartment.
databaseVersionstringThe database version with which the Autonomous AI Database Software Image is to be built.
definedTagsobjectDefined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
displayNamestringThe user-friendly name for the Autonomous AI Database Software Image. The name does not have to be unique.
freeformTagsobjectFree-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm). Example: {"Department": "Finance"}
imageShapeFamilystringTo what shape the image is meant for. (EXACC_SHAPE, EXADATA_SHAPE)
lifecycleDetailsstringDetailed message for the lifecycle state.
lifecycleStatestringThe current state of the Autonomous AI Database Software Image. (AVAILABLE, FAILED, PROVISIONING, EXPIRED, TERMINATED, TERMINATING, UPDATING)
releaseUpdatestringThe Release Updates.
systemTagsobjectSystem tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
timeCreatedstring (date-time)The date and time the Autonomous AI Database Software Image was created.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectautonomousDatabaseSoftwareImageId, regionopc-request-idGets information about the specified Autonomous AI Database Software Image.
listselectcompartmentId, imageShapeFamily, regionlimit, page, sortOrder, sortBy, lifecycleState, opc-request-id, displayNameGets a list of the Autonomous AI Database Software Images in the specified compartment.<br />
createinsertregion, compartmentId, displayName, sourceCdbId, imageShapeFamilyopc-retry-token, opc-request-idcreate Autonomous AI Database Software Image in the specified compartment.<br />
updateupdateautonomousDatabaseSoftwareImageId, regionif-match, opc-request-idUpdates the properties of an Autonomous AI Database Software Image, like add tags
deletedeleteautonomousDatabaseSoftwareImageId, regionif-match, opc-request-idDelete an Autonomous AI Database Software Image
change_compartmentexecautonomousDatabaseSoftwareImageId, region, compartmentIdopc-retry-token, opc-request-id, if-matchMove the Autonomous AI Database Software Image and its dependent resources to the specified compartment.<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.

NameDatatypeDescription
autonomousDatabaseSoftwareImageIdstringThe Autonomous AI Database Software Image [OCID](/Content/General/Concepts/identifiers.htm).
compartmentIdstringThe compartment [OCID](/Content/General/Concepts/identifiers.htm).
imageShapeFamilystringA filter to return only resources that match the given image shape family exactly.
regionstringOCI 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)
displayNamestringA filter to return only resources that match the entire display name given. The match is not case sensitive.
if-matchstringFor optimistic concurrency control. In the PUT or DELETE call for a resource, set the if-match parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value.
lifecycleStatestringA filter to return only resources that match the given lifecycle state exactly.
limitintegerThe maximum number of items to return per page.
opc-request-idstringUnique identifier for the request.
opc-retry-tokenstringA token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations (for example, if a resource has been deleted and purged from the system, then a retry of the original creation request may be rejected).
pagestringThe pagination token to continue listing from.
sortBystringparameter according to which Autonomous AI Database Software Images will be sorted.
sortOrderstringThe sort order to use, either ascending (ASC) or descending (DESC).

SELECT examples​

Gets information about the specified Autonomous AI Database Software Image.

SELECT
id,
autonomousDsiOneOffPatches,
compartmentId,
databaseVersion,
definedTags,
displayName,
freeformTags,
imageShapeFamily,
lifecycleDetails,
lifecycleState,
releaseUpdate,
systemTags,
timeCreated
FROM oci.database.autonomous_database_software_images
WHERE autonomousDatabaseSoftwareImageId = '{{ autonomousDatabaseSoftwareImageId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;

INSERT examples​

create Autonomous AI Database Software Image in the specified compartment.<br />

INSERT INTO oci.database.autonomous_database_software_images (
compartmentId,
definedTags,
displayName,
freeformTags,
imageShapeFamily,
sourceCdbId,
region,
opc-retry-token,
opc-request-id
)
SELECT 
'{{ compartmentId }}' /* required */,
'{{ definedTags }}',
'{{ displayName }}' /* required */,
'{{ freeformTags }}',
'{{ imageShapeFamily }}' /* required */,
'{{ sourceCdbId }}' /* required */,
'{{ region }}',
'{{ opc-retry-token }}',
'{{ opc-request-id }}'
RETURNING
id,
autonomousDsiOneOffPatches,
compartmentId,
databaseVersion,
definedTags,
displayName,
freeformTags,
imageShapeFamily,
lifecycleDetails,
lifecycleState,
releaseUpdate,
systemTags,
timeCreated
;

UPDATE examples​

Updates the properties of an Autonomous AI Database Software Image, like add tags

UPDATE oci.database.autonomous_database_software_images
SET 
definedTags = '{{ definedTags }}',
freeformTags = '{{ freeformTags }}'
WHERE 
autonomousDatabaseSoftwareImageId = '{{ autonomousDatabaseSoftwareImageId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match}}'
AND opc-request-id = '{{ opc-request-id}}'
RETURNING
id,
autonomousDsiOneOffPatches,
compartmentId,
databaseVersion,
definedTags,
displayName,
freeformTags,
imageShapeFamily,
lifecycleDetails,
lifecycleState,
releaseUpdate,
systemTags,
timeCreated;

DELETE examples​

Delete an Autonomous AI Database Software Image

DELETE FROM oci.database.autonomous_database_software_images
WHERE autonomousDatabaseSoftwareImageId = '{{ autonomousDatabaseSoftwareImageId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match }}'
AND opc-request-id = '{{ opc-request-id }}'
;

Lifecycle Methods​

Move the Autonomous AI Database Software Image and its dependent resources to the specified compartment.<br />

EXEC oci.database.autonomous_database_software_images.change_compartment 
@autonomousDatabaseSoftwareImageId='{{ autonomousDatabaseSoftwareImageId }}' --required, 
@region='{{ region }}' --required, 
@opc-retry-token='{{ opc-retry-token }}', 
@opc-request-id='{{ opc-request-id }}', 
@if-match='{{ if-match }}' 
@@json=
'{
"compartmentId": "{{ compartmentId }}"
}'
;