2c.55. Unallocated Boot-Volumes (OCI360_BVOLUMES)

#: click on a column heading to sort on it
 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 ID                                                                                           VARCHAR2(128)
 IMAGE_ID                                                                                     VARCHAR2(128)
 KMS_KEY_ID                                                                                   VARCHAR2(4)
 IS_HYDRATED                                                                                  VARCHAR2(4)
 SIZE_IN_GBS                                                                                  NUMBER
 SIZE_IN_MBS                                                                                  NUMBER
 SYSTEM_TAGS$ORCL_CLOUD$FREE_TIER_RETAINED                                                    VARCHAR2(4)
 VPUS_PER_GB                                                                                  NUMBER
 DEFINED_TAGS$ORACLE_TAGS$CREATEDBY                                                           VARCHAR2(64)
 DEFINED_TAGS$ORACLE_TAGS$CREATEDON                                                           VARCHAR2(32)
 DISPLAY_NAME                                                                                 VARCHAR2(32)
 TIME_CREATED                                                                                 VARCHAR2(32)
 COMPARTMENT_ID                                                                               VARCHAR2(128)
 LIFECYCLE_STATE                                                                              VARCHAR2(16)
 VOLUME_GROUP_ID                                                                              VARCHAR2(4)
 AVAILABILITY_DOMAIN                                                                          VARCHAR2(32)
 SOURCE_DETAILS$ID                                                                            VARCHAR2(1)
 SOURCE_DETAILS$TYPE                                                                          VARCHAR2(1)


with t1 as (select /*+ materialize */ * from OCI360_BVOLUMES),
     t2 as (select /*+ materialize */ * from OCI360_BV_ATTACHS)
SELECT ID,
       IMAGE_ID,
       KMS_KEY_ID,
       IS_HYDRATED,
       SIZE_IN_GBS,
       SIZE_IN_MBS,
       VPUS_PER_GB,
       DISPLAY_NAME,
       TIME_CREATED,
       COMPARTMENT_ID,
       SOURCE_DETAILS$ID,
       SOURCE_DETAILS$TYPE,
       LIFECYCLE_STATE,
       VOLUME_GROUP_ID,
       AVAILABILITY_DOMAIN
FROM   t1
WHERE  not exists (SELECT 1 FROM t2 WHERE t1.id = t2.boot_volume_id and t2.lifecycle_state = 'ATTACHED');


0 rows selected.