2c.57. Boot-Volumes without a backup policy (OCI360_VOLGROUP_BKP)

#	BOOT_VOLUME_NAME	IS_H	SIZE_IN_GBS	VPUS_PER_GB	TIME_CREATED	COMPARTMENT_NAME	LIFECYCLE_STATE	VOLU	AVAILABILITY_DOMAIN	ID
1	oci360comp (Boot Volume)	true	47	10	2020-05-20T14:54:10.816000+00:00	compt_dev_app	AVAILABLE		CYtq:US-ASHBURN-AD-3	ocid1.bootvolume.oc1.iad.000000000000000000000000000000000000000000000000000000000204

#: click on a column heading to sort on it

ERROR:
ORA-04043: object OCI360_VOLGROUP_BKP does not exist



SELECT tb.DISPLAY_NAME BOOT_VOLUME_NAME,
       tb.IS_HYDRATED,
       tb.SIZE_IN_GBS,
       tb.VPUS_PER_GB,
       tb.TIME_CREATED,
       tcomp.NAME COMPARTMENT_NAME,
       tb.LIFECYCLE_STATE,
       tb.VOLUME_GROUP_ID,
       tb.AVAILABILITY_DOMAIN,
       tb.ID
FROM   OCI360_BVOLUMES tb,
       OCI360_COMPARTMENTS tcomp,
       OCI360_BKP_POLICY_ASSIGN tbkppolassign
WHERE  tb.COMPARTMENT_ID = tcomp.ID
AND    tb.ID = tbkppolassign.ASSET_ID (+)
AND    tbkppolassign.ASSET_ID is null
ORDER  BY COMPARTMENT_NAME, tb.TIME_CREATED DESC;


1 rows selected.