3a.1.85. Subnets (OCI360_SUBNETS) 3a.1.85. Subnets (OCI360_SUBNETS)
| # | COMPARTMENT_NAME | VCN_NAME | ID | VCN_ID | DNS_LABEL | CIDR_BLOCK | DISPLAY_NAME | TIME_CREATED | COMPARTMENT_ID | ROUTE_TABLE_ID | DHCP_OPTIONS_ID | LIFECYCLE_STATE | VIRTUAL_ROUTER_I | SUBNET_DOMAIN_NAME | VIRTUAL_ROUTER_MAC | AVAI | PROHIBIT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Test | vcn_test | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000669 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000696 | sub04182234291 | 10.0.1.0/24 | Private Subnet-vcn_test | 2020-04-18T22:34:43.419000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000227 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000631 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000244 | AVAILABLE | 10.0.1.1 | sub04182234291.vcntest.oraclevcn.com | 00:00:17:D5:09:EC | true | |
| 2 | Test | vcn_test | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000674 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000696 | sub04182234290 | 10.0.0.0/24 | Public Subnet-vcn_test | 2020-04-18T22:34:43.018000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000227 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000629 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000244 | AVAILABLE | 10.0.0.1 | sub04182234290.vcntest.oraclevcn.com | 00:00:17:D5:09:EC | false | |
| 3 | compt_ss_net | vcn_dev | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000672 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000694 | subnetdevapp | 10.100.5.0/24 | subnet_dev_app | 2020-04-28T22:31:45.946000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000641 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000234 | AVAILABLE | 10.100.5.1 | subnetdevapp.vcndev.oraclevcn.com | 00:00:17:4C:E7:9B | true | |
| 4 | compt_ss_net | vcn_dev | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000675 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000694 | subnetdevdmz | 10.100.4.0/24 | subnet_dev_dmz | 2020-04-28T22:31:21.985000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000627 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000237 | AVAILABLE | 10.100.4.1 | subnetdevdmz.vcndev.oraclevcn.com | 00:00:17:4C:E7:9B | false | |
| 5 | compt_ss_net | vcn_dev | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000677 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000694 | subnetdevdb | 10.100.6.0/24 | subnet_dev_db | 2020-04-28T22:32:13.951000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000634 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000248 | AVAILABLE | 10.100.6.1 | subnetdevdb.vcndev.oraclevcn.com | 00:00:17:4C:E7:9B | true | |
| 6 | compt_ss_net | vcn_hml | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000673 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000693 | subnethmldb | 10.100.14.0/24 | subnet_hml_db | 2020-04-28T22:36:03.681000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000639 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000240 | AVAILABLE | 10.100.14.1 | subnethmldb.vcnhml.oraclevcn.com | 00:00:17:66:AA:21 | false | |
| 7 | compt_ss_net | vcn_hml | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000676 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000693 | subnethmlapp | 10.100.13.0/24 | subnet_hml_app | 2020-04-28T22:35:19.681000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000628 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000246 | AVAILABLE | 10.100.13.1 | subnethmlapp.vcnhml.oraclevcn.com | 00:00:17:66:AA:21 | true | |
| 8 | compt_ss_net | vcn_hml | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000680 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000693 | subnethmldmz | 10.100.12.0/24 | subnet_hml_dmz | 2020-04-28T22:34:57.792000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000635 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000238 | AVAILABLE | 10.100.12.1 | subnethmldmz.vcnhml.oraclevcn.com | 00:00:17:66:AA:21 | false | |
| 9 | compt_ss_net | vcn_hub | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000678 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000692 | subnethubdmz | 10.100.0.0/24 | subnet_hub_dmz | 2020-04-24T20:29:09.994000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000640 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000236 | AVAILABLE | 10.100.0.1 | subnethubdmz.vcnhub.oraclevcn.com | 00:00:17:2A:14:5F | false | |
| 10 | compt_ss_net | vcn_prd | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000668 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000698 | subnetprddb | 10.100.10.0/24 | subnet_prd_db | 2020-04-24T22:11:59.826000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000632 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000242 | AVAILABLE | 10.100.10.1 | subnetprddb.vcnprd.oraclevcn.com | 00:00:17:6B:52:DC | true | |
| 11 | compt_ss_net | vcn_prd | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000670 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000698 | subnetprdapp | 10.100.9.0/24 | subnet_prd_app | 2020-04-24T22:11:16.885000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000625 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000245 | AVAILABLE | 10.100.9.1 | subnetprdapp.vcnprd.oraclevcn.com | 00:00:17:6B:52:DC | true | |
| 12 | compt_ss_net | vcn_prd | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000679 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000698 | subnetprddmz | 10.100.8.0/24 | subnet_prd_dmz | 2020-04-24T22:10:41.809000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000642 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000249 | AVAILABLE | 10.100.8.1 | subnetprddmz.vcnprd.oraclevcn.com | 00:00:17:6B:52:DC | false | |
| 13 | compt_dev_app | vcn-20200428-1946 | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000671 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000697 | subnet | 10.0.0.0/24 | Public Subnet | 2020-04-28T22:46:29.508000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000636 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000241 | AVAILABLE | 10.0.0.1 | subnet.vcn.oraclevcn.com | 00:00:17:12:88:0F | false |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
VCN_ID VARCHAR2(128)
DNS_LABEL VARCHAR2(16)
CIDR_BLOCK VARCHAR2(16)
DEFINED_TAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DEFINED_TAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DISPLAY_NAME VARCHAR2(32)
TIME_CREATED VARCHAR2(32)
FREEFORM_TAGS$VCN VARCHAR2(32)
COMPARTMENT_ID VARCHAR2(128)
ROUTE_TABLE_ID VARCHAR2(128)
DHCP_OPTIONS_ID VARCHAR2(128)
IPV6_CIDR_BLOCK VARCHAR2(4)
LIFECYCLE_STATE VARCHAR2(16)
VIRTUAL_ROUTER_IP VARCHAR2(16)
SUBNET_DOMAIN_NAME VARCHAR2(64)
VIRTUAL_ROUTER_MAC VARCHAR2(32)
AVAILABILITY_DOMAIN VARCHAR2(4)
IPV6_PUBLIC_CIDR_BLOCK VARCHAR2(4)
IPV6_VIRTUAL_ROUTER_IP VARCHAR2(4)
PROHIBIT_PUBLIC_IP_ON_VNIC VARCHAR2(8)
SECURITY_LIST_IDS VARCHAR2(128)
SELECT distinct
tcomp.NAME COMPARTMENT_NAME,
tvcn.DISPLAY_NAME VCN_NAME,
tsub.ID,
tsub.VCN_ID,
tsub.DNS_LABEL,
tsub.CIDR_BLOCK,
tsub.DISPLAY_NAME,
tsub.TIME_CREATED,
tsub.COMPARTMENT_ID,
tsub.ROUTE_TABLE_ID,
tsub.DHCP_OPTIONS_ID,
tsub.LIFECYCLE_STATE,
tsub.VIRTUAL_ROUTER_IP,
tsub.SUBNET_DOMAIN_NAME,
tsub.VIRTUAL_ROUTER_MAC,
tsub.AVAILABILITY_DOMAIN,
tsub.PROHIBIT_PUBLIC_IP_ON_VNIC
FROM OCI360_SUBNETS tsub,
OCI360_COMPARTMENTS tcomp,
OCI360_VCNS tvcn
WHERE substr(tsub.id,instr(tsub.id,'.',1,3)+1,instr(tsub.id,'.',1,4)-instr(tsub.id,'.',1,3)-1) = 'iad'
AND tsub.COMPARTMENT_ID = tcomp.ID
AND tsub.VCN_ID = tvcn.ID;
13 rows selected.