odb_subnets

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

Overview

Name	odb_subnets
Type	Resource
Id	google.oracledatabase.odb_subnets

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	Identifier. The name of the OdbSubnet resource in the following format: projects/{project}/locations/{location}/odbNetworks/{odb_network}/odbSubnets/{odb_subnet}
cidrRange	string	Required. The CIDR range of the subnet.
createTime	string (google-datetime)	Output only. The date and time that the OdbNetwork was created.
labels	object	Optional. Labels or tags associated with the resource.
purpose	string	Required. Purpose of the subnet. (PURPOSE_UNSPECIFIED, CLIENT_SUBNET, BACKUP_SUBNET)
state	string	Output only. State of the ODB Subnet. (STATE_UNSPECIFIED, PROVISIONING, AVAILABLE, TERMINATING, FAILED)

list

Name	Datatype	Description
name	string	Identifier. The name of the OdbSubnet resource in the following format: projects/{project}/locations/{location}/odbNetworks/{odb_network}/odbSubnets/{odb_subnet}
cidrRange	string	Required. The CIDR range of the subnet.
createTime	string (google-datetime)	Output only. The date and time that the OdbNetwork was created.
labels	object	Optional. Labels or tags associated with the resource.
purpose	string	Required. Purpose of the subnet. (PURPOSE_UNSPECIFIED, CLIENT_SUBNET, BACKUP_SUBNET)
state	string	Output only. State of the ODB Subnet. (STATE_UNSPECIFIED, PROVISIONING, AVAILABLE, TERMINATING, FAILED)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, odbNetworksId, odbSubnetsId		Gets details of a single ODB Subnet.
list	select	projectsId, locationsId, odbNetworksId	filter, orderBy, pageSize, pageToken	Lists all the ODB Subnets in a given ODB Network.
create	insert	projectsId, locationsId, odbNetworksId	odbSubnetId, requestId	Creates a new ODB Subnet in a given ODB Network.
delete	delete	projectsId, locationsId, odbNetworksId, odbSubnetsId	requestId	Deletes a single ODB Subnet.

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

SELECT examples

get

Gets details of a single ODB Subnet.

SELECT
name,
cidrRange,
createTime,
labels,
purpose,
state
FROM google.oracledatabase.odb_subnets
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND odbNetworksId = '{{ odbNetworksId }}' -- required
AND odbSubnetsId = '{{ odbSubnetsId }}' -- required
;

list

Lists all the ODB Subnets in a given ODB Network.

SELECT
name,
cidrRange,
createTime,
labels,
purpose,
state
FROM google.oracledatabase.odb_subnets
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND odbNetworksId = '{{ odbNetworksId }}' -- required
AND filter = '{{ filter }}'
AND orderBy = '{{ orderBy }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;

INSERT examples

create

Creates a new ODB Subnet in a given ODB Network.

INSERT INTO google.oracledatabase.odb_subnets (
data__cidrRange,
data__labels,
data__name,
data__purpose,
projectsId,
locationsId,
odbNetworksId,
odbSubnetId,
requestId
)
SELECT 
'{{ cidrRange }}',
'{{ labels }}',
'{{ name }}',
'{{ purpose }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ odbNetworksId }}',
'{{ odbSubnetId }}',
'{{ requestId }}'
RETURNING
name,
done,
error,
metadata,
response
;

Manifest

# Description fields are for documentation purposes
- name: odb_subnets
props:
  - name: projectsId
    value: "{{ projectsId }}"
    description: Required parameter for the odb_subnets resource.
  - name: locationsId
    value: "{{ locationsId }}"
    description: Required parameter for the odb_subnets resource.
  - name: odbNetworksId
    value: "{{ odbNetworksId }}"
    description: Required parameter for the odb_subnets resource.
  - name: cidrRange
    value: "{{ cidrRange }}"
    description: |
      Required. The CIDR range of the subnet.
  - name: labels
    value: "{{ labels }}"
    description: |
      Optional. Labels or tags associated with the resource.
  - name: name
    value: "{{ name }}"
    description: |
      Identifier. The name of the OdbSubnet resource in the following format: projects/{project}/locations/{location}/odbNetworks/{odb_network}/odbSubnets/{odb_subnet}
  - name: purpose
    value: "{{ purpose }}"
    description: |
      Required. Purpose of the subnet.
    valid_values: ['PURPOSE_UNSPECIFIED', 'CLIENT_SUBNET', 'BACKUP_SUBNET']
  - name: odbSubnetId
    value: "{{ odbSubnetId }}"
  - name: requestId
    value: "{{ requestId }}"

DELETE examples

delete

Deletes a single ODB Subnet.

DELETE FROM google.oracledatabase.odb_subnets
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND odbNetworksId = '{{ odbNetworksId }}' --required
AND odbSubnetsId = '{{ odbSubnetsId }}' --required
AND requestId = '{{ requestId }}'
;