3a.1.94. Local Peering Gateways (OCI360_LOCAL_PEERING) 3a.1.94. Local Peering Gateways (OCI360_LOCAL_PEERING)
| # | ID | VCN_ID | DEFINED_TAGS$ORACLE_TAGS$CREATEDBY | DEFINED_TAGS$ORACLE_TAGS$CREATED | DISPLAY_NAME | TIME_CREATED | COMPARTMENT_ID | PEERING_ | ROUT | LIFECYCLE_STATE | PEER_ADVERTISED_ | PEERING_STATUS_DETAILS | IS_CROSS | PEER_ADVERTISED_ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ocid1.localpeeringgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000583 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000692 | oracleidentitycloudservice/[email protected] | 2020-04-24T22:17:16.340Z | lpg_vcn_hub_prd | 2020-04-24T22:17:16.354000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | PEERED | AVAILABLE | 10.100.8.0/22 | Connected to a peer. | false | 10.100.8.0/22 | |
| 2 | ocid1.localpeeringgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000584 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000698 | oracleidentitycloudservice/[email protected] | 2020-04-24T22:16:59.754Z | lpg_vcn_prd_hub | 2020-04-24T22:16:59.815000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | PEERED | AVAILABLE | 10.100.0.0/22 | Connected to a peer. | false | 10.100.0.0/22 |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
VCN_ID VARCHAR2(128)
DEFINED_TAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DEFINED_TAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DISPLAY_NAME VARCHAR2(16)
TIME_CREATED VARCHAR2(32)
COMPARTMENT_ID VARCHAR2(128)
PEERING_STATUS VARCHAR2(8)
ROUTE_TABLE_ID VARCHAR2(4)
LIFECYCLE_STATE VARCHAR2(16)
PEER_ADVERTISED_CIDR VARCHAR2(16)
PEERING_STATUS_DETAILS VARCHAR2(32)
IS_CROSS_TENANCY_PEERING VARCHAR2(8)
PEER_ADVERTISED_CIDR_DETAILS VARCHAR2(16)
SELECT t1.*
FROM OCI360_LOCAL_PEERING t1
WHERE substr(id,instr(id,'.',1,3)+1,instr(id,'.',1,4)-instr(id,'.',1,3)-1) = 'iad';
2 rows selected.