DBA SECURITY WORLD UPDATES

Pluggable Databases create a container database(root db) and plug many database inside it ..... what's the question in your mind now? why oracle making it so complicated, first create container db then create plugable db? Obviously managing them will require lots of effors... The Benefit whcih we get , all these databases then share the exact same oracle server processes (aka background processes) and memory (Unlike in the previous versions where each database got its own set of background processes and shared memory allocation). Means You will have only one pmon and can create many instance on a single server. Isn't it sounds extraordinary?

Online Data-file Move Online Datafile Move is the very helpful technique implemented by oracle corporation in its 12C release.You need not to be worry about taking the tablespace offline to move the datfile... wowla!!!  Lets see how this magic work... SELECT file_id, file_name FROM dba_data_files ORDER BY file_id; FILE_ID FILE_NAME ---------- ---------------------------------------------------------------------- 1 /u01/app/oracle/oradata/cdb1/system01.dbf 3 /u01/app/oracle/oradata/cdb1/sysaux01.dbf 4 /u01/app/oracle/oradata/cdb1/undotbs01.dbf 6 /u01/app/oracle/oradata/cdb1/users01.dbf SQL> ALTER DATABASE MOVE DATAFILE '/u01/app/oracle/oradata/cdb1/system01.dbf' TO '/tmp/system01.dbf'; Database altered. SQL> 　 SQL> SELECT file_id, file_name FROM dba_data_files WHERE file_id = 1; FILE_ID FILE_NAME ---------- ---------------------------------------------------------------------- 1 /tmp/system01.dbf SQL...