Flashback Database in Multi-Tenant Architecture

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

Step 2: Set flashback retention target

Step 3: Enable flashback database

Step 4: Check […]

Read More

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 […]

Read More