6a.580. Database Systems Scan IDs (OCI360_DB_SYSTEMS)
WHERE SCAN_IP_IDS is not null
*
ERROR at line 7:
ORA-00904: "SCAN_IP_IDS": invalid identifier
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
DATA_STORAGE_SIZE_IN_GBS NUMBER(1)
LIFECYCLE_STATE VARCHAR2(1)
RECO_STORAGE_SIZE_IN_GB NUMBER(1)
ID VARCHAR2(1)
SELECT ID,
CLUSTER_NAME,
DISPLAY_NAME,
SCAN_IP_IDS
FROM OCI360_DB_SYSTEMS t1
WHERE SCAN_IP_IDS is not null;
-1 rows selected.
oci360 (c) 2020, All rights reserved. oci360 v20.06 (2020-06-25) based on moat369 v2002 (2020-02-27). Timestamp: 2020-06-30T16:48:14