ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Used with c scripts prior to upgrading the data dictionary.
BEGIN
IF dbms_registry_simple.is_db_consolidated THEN
dbms_output.put_line('This is a Consolidated DB');
ELSE
dbms_output.put_line('Not a Consolidated DB');
END IF;
END;
/
Returns TRUE if the current session is connected to a PDB
dbms_registry_simple.is_db_pdb RETURN BOOLEAN;
conn / as sysdba
BEGIN
IF dbms_registry_simple.is_db_pdb THEN
dbms_output.put_line('This is a PDB');
ELSE
dbms_output.put_line('Not a PDB');
END IF;
END;
/ Not a PDB
PL/SQL procedure successfully completed.
ALTER SESSION SET CONTAINER = pdbdev;
BEGIN
IF dbms_registry_simple.is_db_pdb THEN
dbms_output.put_line('This is a PDB');
ELSE
dbms_output.put_line('Not a PDB');
END IF;
END;
/ This is a PDB
BEGIN
IF dbms_registry_simple.is_db_pdb_seed THEN
dbms_output.put_line('This is PDB$SEED');
ELSE
dbms_output.put_line('Not PDB$SEED');
END IF;
END;
/ Not PDB$SEED
PL/SQL procedure successfully completed.
ALTER SESSION SET CONTAINER = pdb$seed;
BEGIN
IF dbms_registry_simple.is_db_pdb_seed THEN
dbms_output.put_line('This is PDB$SEED');
ELSE
dbms_output.put_line('Not PDB$SEED');
END IF;
END;
/ This is PDB$SEED
Returns TRUE if the current session is connected to the ROOT CONTAINER
dbms_registry_simple.is_db_root RETURN BOOLEAN;
conn sys@pdbdev as sysdba
BEGIN
IF dbms_registry_simple.is_db_root THEN
dbms_output.put_line('This is CDB$ROOT');
ELSE
dbms_output.put_line('Not CDB$ROOT');
END IF;
END;
/ This is CDB$ROOT
PL/SQL procedure successfully completed.
ALTER SESSION SET CONTAINER = pdbdev;
BEGIN
IF dbms_registry_simple.is_db_root THEN
dbms_output.put_line('This is CDB$ROOT');
ELSE
dbms_output.put_line('Not CDB$ROOT');
END IF;
END;
/ Not CDB$ROOT