Flashback Database is a very powerful feature offered by Oracle. We can enable flashback in CDB same way we are doing in the non-cdb database. Enable Flashback Database in CDB : Step 1 : Check flashback_on from v$database SQL> select name,open_mode,cdb,flashback_on from v$database; NAME OPEN_MODE CDB FLASHBACK_ON ——— ——————– — —————— DUPCDB READ WRITE YES […]
Articles Tagged: Oracle database 12cr2
Managing Tablespace in Multi-Tenant Environment Part – II
In the previous article, we have seen System tablespace and Users tablespace. Managing Tablespace in Multi-Tenant Environment Part – I In this article we will see Temporary tablespace and Undo tablespace : Temporary Tablespace : Every CDB$ROOT can have one default temporary tablespace or tablespace group. Pluggable databases must have their own temporary tablespace to […]