2d.62. Boot-Volume Backups - Not Available (OCI360_BV_BACKUPS)

 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 BOOT_VOLUME_ID                                                                               VARCHAR2(1)
 COMPARTMENT_ID                                                                               VARCHAR2(1)
 DISPLAY_NAME                                                                                 VARCHAR2(1)
 EXPIRATION_TIME                                                                              VARCHAR2(1)
 IMAGE_ID                                                                                     VARCHAR2(1)
 LIFECYCLE_STATE                                                                              VARCHAR2(1)
 SIZE_IN_GBS                                                                                  NUMBER(1)
 SOURCE_TYPE                                                                                  VARCHAR2(1)
 TIME_CREATED                                                                                 VARCHAR2(1)
 TIME_REQUEST_RECEIVED                                                                        VARCHAR2(1)
 UNIQUE_SIZE_IN_GBS                                                                           NUMBER(1)
 ID                                                                                           VARCHAR2(1)
 TYPE                                                                                         VARCHAR2(1)


SELECT t2.display_name BOOTVOLUME_NAME,
       t1.type,
       t1.size_in_gbs,
       t1.source_type,
       t1.display_name,
       t1.time_created,
       t3.name COMPARTMENT_NAME,
       t1.expiration_time,
       t1.lifecycle_state,
       t1.unique_size_in_gbs,
       t1.time_request_received,
       t1.image_id,
       t1.boot_volume_id,
       t1.id
FROM   OCI360_BV_BACKUPS t1,
       OCI360_BVOLUMES t2,
       OCI360_COMPARTMENTS t3
WHERE  t1.lifecycle_state != 'AVAILABLE'
AND    t1.boot_volume_id = t2.id (+)
AND    t1.compartment_id = t3.id (+);


0 rows selected.