cloud_exadata_infrastructures

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

Overview

Name	cloud_exadata_infrastructures
Type	Resource
Id	azure_isv.oracle.cloud_exadata_infrastructures

Fields

The following fields are returned by SELECT queries:

get

Azure operation completed successfully.

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The resource-specific properties for this resource.
tags	object	Resource tags.
zones	array	CloudExadataInfrastructure zones

list_by_resource_group

Azure operation completed successfully.

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The resource-specific properties for this resource.
tags	object	Resource tags.
zones	array	CloudExadataInfrastructure zones

list_by_subscription

Azure operation completed successfully.

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The resource-specific properties for this resource.
tags	object	Resource tags.
zones	array	CloudExadataInfrastructure zones

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, cloudexadatainfrastructurename		Get a CloudExadataInfrastructure
list_by_resource_group	select	subscriptionId, resourceGroupName		List CloudExadataInfrastructure resources by resource group
list_by_subscription	select	subscriptionId		List CloudExadataInfrastructure resources by subscription ID
create_or_update	insert	subscriptionId, resourceGroupName, cloudexadatainfrastructurename, data__zones		Create a CloudExadataInfrastructure
update	update	subscriptionId, resourceGroupName, cloudexadatainfrastructurename		Update a CloudExadataInfrastructure
delete	delete	subscriptionId, resourceGroupName, cloudexadatainfrastructurename		Delete a CloudExadataInfrastructure
add_storage_capacity	exec	subscriptionId, resourceGroupName, cloudexadatainfrastructurename		Perform add storage capacity on exadata infra

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
cloudexadatainfrastructurename	string	CloudExadataInfrastructure name
resourceGroupName	string	The name of the resource group. The name is case insensitive.
subscriptionId	string (uuid)	The ID of the target subscription. The value must be an UUID.

SELECT examples

get

Get a CloudExadataInfrastructure

SELECT
location,
properties,
tags,
zones
FROM azure_isv.oracle.cloud_exadata_infrastructures
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND cloudexadatainfrastructurename = '{{ cloudexadatainfrastructurename }}' -- required
;

list_by_resource_group

List CloudExadataInfrastructure resources by resource group

SELECT
location,
properties,
tags,
zones
FROM azure_isv.oracle.cloud_exadata_infrastructures
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
;

list_by_subscription

List CloudExadataInfrastructure resources by subscription ID

SELECT
location,
properties,
tags,
zones
FROM azure_isv.oracle.cloud_exadata_infrastructures
WHERE subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

create_or_update

Create a CloudExadataInfrastructure

INSERT INTO azure_isv.oracle.cloud_exadata_infrastructures (
data__properties,
data__zones,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
cloudexadatainfrastructurename
)
SELECT 
'{{ properties }}',
'{{ zones }}' /* required */,
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ cloudexadatainfrastructurename }}'
RETURNING
location,
properties,
tags,
zones
;

Manifest

# Description fields are for documentation purposes
- name: cloud_exadata_infrastructures
  props:
    - name: subscriptionId
      value: string (uuid)
      description: Required parameter for the cloud_exadata_infrastructures resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the cloud_exadata_infrastructures resource.
    - name: cloudexadatainfrastructurename
      value: string
      description: Required parameter for the cloud_exadata_infrastructures resource.
    - name: properties
      value: object
      description: |
        The resource-specific properties for this resource.
    - name: zones
      value: array
      description: |
        CloudExadataInfrastructure zones
    - name: tags
      value: object
      description: |
        Resource tags.
    - name: location
      value: string
      description: |
        The geo-location where the resource lives

UPDATE examples

update

Update a CloudExadataInfrastructure

UPDATE azure_isv.oracle.cloud_exadata_infrastructures
SET 
data__zones = '{{ zones }}',
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE 
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND cloudexadatainfrastructurename = '{{ cloudexadatainfrastructurename }}' --required
RETURNING
location,
properties,
tags,
zones;

DELETE examples

delete

Delete a CloudExadataInfrastructure

DELETE FROM azure_isv.oracle.cloud_exadata_infrastructures
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND cloudexadatainfrastructurename = '{{ cloudexadatainfrastructurename }}' --required
;

Lifecycle Methods

add_storage_capacity

Perform add storage capacity on exadata infra

EXEC azure_isv.oracle.cloud_exadata_infrastructures.add_storage_capacity 
@subscriptionId='{{ subscriptionId }}' --required, 
@resourceGroupName='{{ resourceGroupName }}' --required, 
@cloudexadatainfrastructurename='{{ cloudexadatainfrastructurename }}' --required
;