There are two types of Undo Modes in 12.2 1) Shared Undo - The Undo tablespace is common, it is shared among the entire CDB. The Management of undo tablespace…

Relocating an Online Data File SQL> ALTER DATABASE MOVE DATAFILE '/rman_backup/backup/datafile1' TO '+DATA'; Database altered. Copying an Online Data File This example copies the data file to  +DEV_DG and the…

11g When OMF is enabled and If a datafile location is incorrect the file gets created in dbs location SQL> show parameter db_create_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_create_file_dest string…

Managing tablespace in container database is similar to non-container database. Provided you are logged in as a privileged user and point to right container. Manage Tablespace in CDB SQL> show…

Common user password we can change from only cdb level .container class is optional. CDB container: ==================================== SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> SQL> alter user C##USERTEST identified by…

From oracle 12c onwards the default user’s account passwords have to change from cdb container. container class is optional.  sys user password change ======================= CDB level using container class with…

From 12c onwards we have new feature called lockdown profile to control the PDB level activities. It can be created in CDB container.  SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL>…

Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Roles: Collection of privileges called role. In 12c we have 2 different types…

Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Grants: oracle12c have two variant of grants. They are: 1) Common grants 2)…