Skip to main content

drg_route_tables

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

Overview​

Namedrg_route_tables
TypeResource
Idoci.network.drg_route_tables

Fields​

The following fields are returned by SELECT queries:

The DRG route table was retrieved.

NameDatatypeDescription
idstringThe [OCID](/iaas/Content/General/Concepts/identifiers.htm) of the DRG route table.
compartmentIdstringThe [OCID](/iaas/Content/General/Concepts/identifiers.htm) of the compartment the DRG is in. The DRG route table is always in the same compartment as the DRG.
definedTagsobjectDefined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/iaas/Content/General/Concepts/resourcetags.htm). Example: {"Operations": {"CostCenter": "42"}}
displayNamestringA user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
drgIdstringThe [OCID](/iaas/Content/General/Concepts/identifiers.htm) of the DRG the DRG that contains this route table.
freeformTagsobjectFree-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see [Resource Tags](/iaas/Content/General/Concepts/resourcetags.htm). Example: {"Department": "Finance"}
importDrgRouteDistributionIdstringThe [OCID](/iaas/Content/General/Concepts/identifiers.htm) of the import route distribution used to specify how incoming route advertisements from referenced attachments are inserted into the DRG route table.
isEcmpEnabledbooleanIf you want traffic to be routed using ECMP across your virtual circuits or IPSec tunnels to your on-premises network, enable ECMP on the DRG route table to which these attachments import routes.
lifecycleStatestringThe DRG route table's current state. (PROVISIONING, AVAILABLE, TERMINATING, TERMINATED)
timeCreatedstring (date-time)The date and time the DRG route table was created, in the format defined by [RFC3339](https:​//tools.ietf.org/html/rfc3339). Example: 2016-08-25T21:10:29.600Z

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectdrgRouteTableId, regionGets the specified DRG route table's information.
listselectdrgId, regionlimit, page, displayName, sortBy, sortOrder, importDrgRouteDistributionId, lifecycleStateLists the DRG route tables for the specified DRG.<br /><br />Use the ListDrgRouteRules operation to retrieve the route rules in a table.<br />
createinsertregion, drgIdopc-retry-tokenCreates a new DRG route table for the specified DRG. Assign the DRG route table to a DRG attachment<br />using the UpdateDrgAttachment or CreateDrgAttachment operations.<br />
updateupdatedrgRouteTableId, regionif-matchUpdates the specified DRG route table.<br />
deletedeletedrgRouteTableId, regionif-matchDeletes the specified DRG route table. There must not be any DRG attachments assigned.<br />
add_drg_route_rulesexecdrgRouteTableId, regionopc-retry-tokenAdds one or more static route rules to the specified DRG route table.<br />
remove_drg_route_rulesexecdrgRouteTableId, regionRemoves one or more route rules from the specified DRG route table.<br />
remove_import_drg_route_distributionexecdrgRouteTableId, regionopc-request-id, if-matchRemoves the import route distribution from the DRG route table so no routes are imported<br />into it.<br />

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
drgIdstringThe [OCID](/iaas/Content/General/Concepts/identifiers.htm) of the DRG.
drgRouteTableIdstringThe [OCID](/iaas/Content/General/Concepts/identifiers.htm) of the DRG route table.
regionstringOCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
displayNamestringA filter to return only resources that match the given display name exactly.
if-matchstringFor optimistic concurrency control. In the PUT or DELETE call for a resource, set the if-match parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value.
importDrgRouteDistributionIdstringThe [OCID](/iaas/Content/General/Concepts/identifiers.htm) of the import route distribution.
lifecycleStatestringA filter that only returns matches for the specified lifecycle state. The value is case insensitive.
limitintegerFor list pagination. The maximum number of results per page, or items to return in a paginated "List" call. For important details about how pagination works, see [List Pagination](/iaas/Content/API/Concepts/usingapi.htm#nine). Example: 50
opc-request-idstringUnique identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
opc-retry-tokenstringA token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations (for example, if a resource has been deleted and purged from the system, then a retry of the original creation request may be rejected).
pagestringFor list pagination. The value of the opc-next-page response header from the previous "List" call. For important details about how pagination works, see [List Pagination](/iaas/Content/API/Concepts/usingapi.htm#nine).
sortBystringThe field to sort by. You can provide one sort order (sortOrder). Default order for TIMECREATED is descending. Default order for DISPLAYNAME is ascending. The DISPLAYNAME sort order is case sensitive. Note: In general, some "List" operations (for example, ListInstances) let you optionally filter by availability domain if the scope of the resource type is within a single availability domain. If you call one of these "List" operations without specifying an availability domain, the resources are grouped by availability domain, then sorted.
sortOrderstringThe sort order to use, either ascending (ASC) or descending (DESC). The DISPLAYNAME sort order is case sensitive.

SELECT examples​

Gets the specified DRG route table's information.

SELECT
id,
compartmentId,
definedTags,
displayName,
drgId,
freeformTags,
importDrgRouteDistributionId,
isEcmpEnabled,
lifecycleState,
timeCreated
FROM oci.network.drg_route_tables
WHERE drgRouteTableId = '{{ drgRouteTableId }}' -- required
AND region = '{{ region }}' -- required
;

INSERT examples​

Creates a new DRG route table for the specified DRG. Assign the DRG route table to a DRG attachment<br />using the UpdateDrgAttachment or CreateDrgAttachment operations.<br />

INSERT INTO oci.network.drg_route_tables (
definedTags,
displayName,
drgId,
freeformTags,
importDrgRouteDistributionId,
isEcmpEnabled,
region,
opc-retry-token
)
SELECT
'{{ definedTags }}',
'{{ displayName }}',
'{{ drgId }}' /* required */,
'{{ freeformTags }}',
'{{ importDrgRouteDistributionId }}',
{{ isEcmpEnabled }},
'{{ region }}',
'{{ opc-retry-token }}'
RETURNING
id,
compartmentId,
definedTags,
displayName,
drgId,
freeformTags,
importDrgRouteDistributionId,
isEcmpEnabled,
lifecycleState,
timeCreated
;

UPDATE examples​

Updates the specified DRG route table.<br />

UPDATE oci.network.drg_route_tables
SET
definedTags = '{{ definedTags }}',
displayName = '{{ displayName }}',
freeformTags = '{{ freeformTags }}',
importDrgRouteDistributionId = '{{ importDrgRouteDistributionId }}',
isEcmpEnabled = {{ isEcmpEnabled }}
WHERE
drgRouteTableId = '{{ drgRouteTableId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match}}'
RETURNING
id,
compartmentId,
definedTags,
displayName,
drgId,
freeformTags,
importDrgRouteDistributionId,
isEcmpEnabled,
lifecycleState,
timeCreated;

DELETE examples​

Deletes the specified DRG route table. There must not be any DRG attachments assigned.<br />

DELETE FROM oci.network.drg_route_tables
WHERE drgRouteTableId = '{{ drgRouteTableId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match }}'
;

Lifecycle Methods​

Adds one or more static route rules to the specified DRG route table.<br />

EXEC oci.network.drg_route_tables.add_drg_route_rules
@drgRouteTableId='{{ drgRouteTableId }}' --required,
@region='{{ region }}' --required,
@opc-retry-token='{{ opc-retry-token }}'
@@json=
'{
"routeRules": "{{ routeRules }}"
}'
;