cloud_exadata_infrastructures

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

Overview

Name	cloud_exadata_infrastructures
Type	Resource
Id	google.oracledatabase.cloud_exadata_infrastructures

Fields

Name	Datatype	Description
name	string	Identifier. The name of the Exadata Infrastructure resource with the format: projects/{project}/locations/{region}/cloudExadataInfrastructures/{cloud_exadata_infrastructure}
createTime	string	Output only. The date and time that the Exadata Infrastructure was created.
displayName	string	Optional. User friendly name for this resource.
entitlementId	string	Output only. Entitlement ID of the private offer against which this infrastructure resource is provisioned.
gcpOracleZone	string	Optional. GCP location where Oracle Exadata is hosted.
labels	object	Optional. Labels or tags associated with the resource.
properties	object	Various properties of Exadata Infrastructure.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	cloudExadataInfrastructuresId, locationsId, projectsId	Gets details of a single Exadata Infrastructure.
list	SELECT	locationsId, projectsId	Lists Exadata Infrastructures in a given project and location.
create	INSERT	locationsId, projectsId	Creates a new Exadata Infrastructure in a given project and location.
delete	DELETE	cloudExadataInfrastructuresId, locationsId, projectsId	Deletes a single Exadata Infrastructure.

SELECT examples

Lists Exadata Infrastructures in a given project and location.

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

INSERT example

Use the following StackQL query and manifest file to create a new cloud_exadata_infrastructures resource.

All Properties

/*+ create */
INSERT INTO google.oracledatabase.cloud_exadata_infrastructures (
locationsId,
projectsId,
name,
displayName,
gcpOracleZone,
properties,
labels
)
SELECT 
'{{ locationsId }}',
'{{ projectsId }}',
'{{ name }}',
'{{ displayName }}',
'{{ gcpOracleZone }}',
'{{ properties }}',
'{{ labels }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: displayName
      value: string
    - name: gcpOracleZone
      value: string
    - name: entitlementId
      value: string
    - name: properties
      value:
        - name: ocid
          value: string
        - name: computeCount
          value: integer
        - name: storageCount
          value: integer
        - name: totalStorageSizeGb
          value: integer
        - name: availableStorageSizeGb
          value: integer
        - name: maintenanceWindow
          value:
            - name: preference
              value: string
            - name: months
              value:
                - string
            - name: weeksOfMonth
              value:
                - integer
            - name: daysOfWeek
              value:
                - string
            - name: hoursOfDay
              value:
                - integer
            - name: leadTimeWeek
              value: integer
            - name: patchingMode
              value: string
            - name: customActionTimeoutMins
              value: integer
            - name: isCustomActionTimeoutEnabled
              value: boolean
        - name: state
          value: string
        - name: shape
          value: string
        - name: ociUrl
          value: string
        - name: cpuCount
          value: integer
        - name: maxCpuCount
          value: integer
        - name: memorySizeGb
          value: integer
        - name: maxMemoryGb
          value: integer
        - name: dbNodeStorageSizeGb
          value: integer
        - name: maxDbNodeStorageSizeGb
          value: integer
        - name: dataStorageSizeTb
          value: number
        - name: maxDataStorageTb
          value: number
        - name: activatedStorageCount
          value: integer
        - name: additionalStorageCount
          value: integer
        - name: dbServerVersion
          value: string
        - name: storageServerVersion
          value: string
        - name: nextMaintenanceRunId
          value: string
        - name: nextMaintenanceRunTime
          value: string
        - name: nextSecurityMaintenanceRunTime
          value: string
        - name: customerContacts
          value:
            - - name: email
                value: string
        - name: monthlyStorageServerVersion
          value: string
        - name: monthlyDbServerVersion
          value: string
    - name: labels
      value: object
    - name: createTime
      value: string

DELETE example

Deletes the specified cloud_exadata_infrastructures resource.

/*+ delete */
DELETE FROM google.oracledatabase.cloud_exadata_infrastructures
WHERE cloudExadataInfrastructuresId = '{{ cloudExadataInfrastructuresId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';