CREATE OR REPLACE FORCE EDITIONABLE VIEW "OTHQ_OWN"."CMDB_NEXT_EXA_CDB_VW" 
(
    "VERSION",
    "SCAN_NAME",
    "RESOURCE_USER",
    "PDB_SIZE",
    "PDB_COUNT",
    "PDB_CAPACITY",
    "PDBS_IN_SMD",
    "AVAILABILITY_DOMAIN",
    "OPERATING_STATUS",
    "MOLECULE",
    "LOGICAL_DATA_CENTER",
    "ID",
    "EXACS_GROUP",
    "EXA_CLUSTER_INSTANCE_SHAPE",
    "EXA_CLUSTER_CREATED",
    "DB_INSTANCE",
    "DATAGUARD_STATUS"
)
DEFAULT COLLATION "USING_NLS_COMP"
AS
SELECT
    t."VERSION",
    t."SCAN_NAME",
    t."RESOURCE_USER",
    t."PDB_SIZE",
    t."PDB_COUNT",
    t."PDB_CAPACITY",
    t."PDBS_IN_SMD",
    t."AVAILABILITY_DOMAIN",
    t."OPERATING_STATUS",
    t."MOLECULE",
    t."LOGICAL_DATA_CENTER",
    t."ID",
    t."EXACS_GROUP",
    t."EXA_CLUSTER_INSTANCE_SHAPE",
    t."EXA_CLUSTER_CREATED",
    t."DB_INSTANCE",
    t."DATAGUARD_STATUS"
FROM
    "OTHQ_OWN"."SRC_CMDB_NEXT_EXA_CDB_TB" t
WHERE
    t."MOLECULE" = 'production';