exascale_db_storage_vaults

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

Overview

Name	exascale_db_storage_vaults
Type	Resource
Id	google.oracledatabase.exascale_db_storage_vaults

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	Identifier. The resource name of the ExascaleDbStorageVault. Format: projects/{project}/locations/{location}/exascaleDbStorageVaults/{exascale_db_storage_vault}
createTime	string (google-datetime)	Output only. The date and time when the ExascaleDbStorageVault was created.
displayName	string	Required. The display name for the ExascaleDbStorageVault. The name does not have to be unique within your project. The name must be 1-255 characters long and can only contain alphanumeric characters.
entitlementId	string	Output only. The ID of the subscription entitlement associated with the ExascaleDbStorageVault.
gcpOracleZone	string	Optional. The GCP Oracle zone where Oracle ExascaleDbStorageVault is hosted. Example: us-east4-b-r2. If not specified, the system will pick a zone based on availability.
labels	object	Optional. The labels or tags associated with the ExascaleDbStorageVault.
properties	object	Required. The properties of the ExascaleDbStorageVault. (id: ExascaleDbStorageVaultProperties)

list

Name	Datatype	Description
name	string	Identifier. The resource name of the ExascaleDbStorageVault. Format: projects/{project}/locations/{location}/exascaleDbStorageVaults/{exascale_db_storage_vault}
createTime	string (google-datetime)	Output only. The date and time when the ExascaleDbStorageVault was created.
displayName	string	Required. The display name for the ExascaleDbStorageVault. The name does not have to be unique within your project. The name must be 1-255 characters long and can only contain alphanumeric characters.
entitlementId	string	Output only. The ID of the subscription entitlement associated with the ExascaleDbStorageVault.
gcpOracleZone	string	Optional. The GCP Oracle zone where Oracle ExascaleDbStorageVault is hosted. Example: us-east4-b-r2. If not specified, the system will pick a zone based on availability.
labels	object	Optional. The labels or tags associated with the ExascaleDbStorageVault.
properties	object	Required. The properties of the ExascaleDbStorageVault. (id: ExascaleDbStorageVaultProperties)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, exascaleDbStorageVaultsId		Gets details of a single ExascaleDB Storage Vault.
list	select	projectsId, locationsId	pageSize, pageToken, filter, orderBy	Lists all the ExascaleDB Storage Vaults for the given project and location.
create	insert	projectsId, locationsId	exascaleDbStorageVaultId, requestId	Creates a new ExascaleDB Storage Vault resource.
delete	delete	projectsId, locationsId, exascaleDbStorageVaultsId	requestId	Deletes a single ExascaleDB Storage Vault.

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
exascaleDbStorageVaultsId	string
locationsId	string
projectsId	string
exascaleDbStorageVaultId	string
filter	string
orderBy	string
pageSize	integer (int32)
pageToken	string
requestId	string

SELECT examples

get

Gets details of a single ExascaleDB Storage Vault.

SELECT
name,
createTime,
displayName,
entitlementId,
gcpOracleZone,
labels,
properties
FROM google.oracledatabase.exascale_db_storage_vaults
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND exascaleDbStorageVaultsId = '{{ exascaleDbStorageVaultsId }}' -- required
;

list

Lists all the ExascaleDB Storage Vaults for the given project and location.

SELECT
name,
createTime,
displayName,
entitlementId,
gcpOracleZone,
labels,
properties
FROM google.oracledatabase.exascale_db_storage_vaults
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}'
AND orderBy = '{{ orderBy }}'
;

INSERT examples

create

Creates a new ExascaleDB Storage Vault resource.

INSERT INTO google.oracledatabase.exascale_db_storage_vaults (
data__name,
data__displayName,
data__gcpOracleZone,
data__properties,
data__labels,
projectsId,
locationsId,
exascaleDbStorageVaultId,
requestId
)
SELECT 
'{{ name }}',
'{{ displayName }}',
'{{ gcpOracleZone }}',
'{{ properties }}',
'{{ labels }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ exascaleDbStorageVaultId }}',
'{{ requestId }}'
RETURNING
name,
done,
error,
metadata,
response
;

Manifest

# Description fields are for documentation purposes
- name: exascale_db_storage_vaults
  props:
    - name: projectsId
      value: string
      description: Required parameter for the exascale_db_storage_vaults resource.
    - name: locationsId
      value: string
      description: Required parameter for the exascale_db_storage_vaults resource.
    - name: name
      value: string
      description: >
        Identifier. The resource name of the ExascaleDbStorageVault. Format: projects/{project}/locations/{location}/exascaleDbStorageVaults/{exascale_db_storage_vault}
        
    - name: displayName
      value: string
      description: >
        Required. The display name for the ExascaleDbStorageVault. The name does not have to be unique within your project. The name must be 1-255 characters long and can only contain alphanumeric characters.
        
    - name: gcpOracleZone
      value: string
      description: >
        Optional. The GCP Oracle zone where Oracle ExascaleDbStorageVault is hosted. Example: us-east4-b-r2. If not specified, the system will pick a zone based on availability.
        
    - name: properties
      value: object
      description: >
        Required. The properties of the ExascaleDbStorageVault.
        
    - name: labels
      value: object
      description: >
        Optional. The labels or tags associated with the ExascaleDbStorageVault.
        
    - name: exascaleDbStorageVaultId
      value: string
    - name: requestId
      value: string

DELETE examples

delete

Deletes a single ExascaleDB Storage Vault.

DELETE FROM google.oracledatabase.exascale_db_storage_vaults
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND exascaleDbStorageVaultsId = '{{ exascaleDbStorageVaultsId }}' --required
AND requestId = '{{ requestId }}'
;