Skip to main content

exascale_db_storage_vaults

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

Overview​

Nameexascale_db_storage_vaults
TypeResource
Idazure_isv.oracledatabase.exascale_db_storage_vaults

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
additionalFlashCacheInPercentintegerThe size of additional Flash Cache in percentage of High Capacity database storage.
attachedShapeAttributesarrayThe shapeAttribute of the Exadata VM cluster(s) associated with the Exadata Database Storage Vault.
descriptionstringExadata Database Storage Vault description.
displayNamestringThe user-friendly name for the Exadata Database Storage Vault. The name does not need to be unique. Required.
exadataInfrastructureIdstringCloud Exadata infrastructure ID.
highCapacityDatabaseStorageobjectResponse exadata Database Storage Details.
highCapacityDatabaseStorageInputobjectCreate exadata Database Storage Details. Required.
lifecycleDetailsstringAdditional information about the current lifecycle state.
lifecycleStatestringExadata Database Storage Vault lifecycle state. Known values are: "Provisioning", "Available", "Updating", "Terminating", "Terminated", and "Failed". (Provisioning, Available, Updating, Terminating, Terminated, Failed)
locationstringThe geo-location where the resource lives. Required.
ociUrlstringHTTPS link to OCI resources exposed to Azure Customer via Azure Interface.
ocidstringThe OCID of the Exadata Database Storage Vault.
provisioningStatestringExadata Database Storage Vault provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
timeZonestringThe time zone that you want to use for the Exadata Database Storage Vault.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
vmClusterCountintegerThe number of Exadata VM clusters used the Exadata Database Storage Vault.
zonesarrayThe availability zones.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, exascale_db_storage_vault_name, subscription_idGet a ExascaleDbStorageVault.
list_by_resource_groupselectresource_group_name, subscription_idList ExascaleDbStorageVault resources by resource group.
list_by_subscriptionselectsubscription_idList ExascaleDbStorageVault resources by subscription ID.
createinsertresource_group_name, exascale_db_storage_vault_name, subscription_id, locationCreate a ExascaleDbStorageVault.
updateupdateresource_group_name, exascale_db_storage_vault_name, subscription_idUpdate a ExascaleDbStorageVault.
deletedeleteresource_group_name, exascale_db_storage_vault_name, subscription_idDelete a ExascaleDbStorageVault.

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
exascale_db_storage_vault_namestringThe name of the ExascaleDbStorageVault. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples​

Get a ExascaleDbStorageVault.

SELECT
id,
name,
additionalFlashCacheInPercent,
attachedShapeAttributes,
description,
displayName,
exadataInfrastructureId,
highCapacityDatabaseStorage,
highCapacityDatabaseStorageInput,
lifecycleDetails,
lifecycleState,
location,
ociUrl,
ocid,
provisioningState,
systemData,
tags,
timeZone,
type,
vmClusterCount,
zones
FROM azure_isv.oracledatabase.exascale_db_storage_vaults
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND exascale_db_storage_vault_name = '{{ exascale_db_storage_vault_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples​

Create a ExascaleDbStorageVault.

INSERT INTO azure_isv.oracledatabase.exascale_db_storage_vaults (
tags,
location,
properties,
zones,
resource_group_name,
exascale_db_storage_vault_name,
subscription_id
)
SELECT 
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ zones }}',
'{{ resource_group_name }}',
'{{ exascale_db_storage_vault_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type,
zones
;

UPDATE examples​

Update a ExascaleDbStorageVault.

UPDATE azure_isv.oracledatabase.exascale_db_storage_vaults
SET 
tags = '{{ tags }}'
WHERE 
resource_group_name = '{{ resource_group_name }}' --required
AND exascale_db_storage_vault_name = '{{ exascale_db_storage_vault_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type,
zones;

DELETE examples​

Delete a ExascaleDbStorageVault.

DELETE FROM azure_isv.oracledatabase.exascale_db_storage_vaults
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND exascale_db_storage_vault_name = '{{ exascale_db_storage_vault_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;