Skip to Main Content

Breadcrumb

Easter

Question and Answer

Connor McDonald

Thanks for the question, RKB.

Asked: February 25, 2020 - 6:11 pm UTC

Answered by: Connor McDonald - Last updated: February 26, 2020 - 1:41 am UTC

Category: Database Administration - Version: 18.3.0.0.0

Viewed 100+ times

You Asked

Our DB version is 18.3.0.0.
We want to set a Global Temporary tablespace at CDB level and drop the Temporary tablespace at the PDB level.

1. The DEFAULT_TEMP_TABLESPACE is set in root container.
2. While in the Pluggable, when trying to drop the temporary tablespace or change the default, getting errors.
ORA-00959: tablespace 'ROOT_TEMP' does not exist
ORA-12906: cannot drop default temporary tablespace

What is the correct procedure to make use of Root's global temporary tablespace on the existing instances.
OR
Is this functionality still unavailable [Doc ID 2004595.1].



and we said...

What is the correct procedure to make use of Root's global temporary tablespace on the existing instances.


I think this probably stemmed from a documentation error or misinterpretation. To my knowledge, there has never been a goal to have a single temp for all pluggables to share. If anything, we've been going the other direction, eg, dedicated temp tablespaces available to individual instances for RAC nodes.

I would just be creating a temp tablespace for each pdb

We're not taking reviews currently, so please try again later if you want to add a review.

More to Explore

Multitenant

All of the benefits of the multi-tenant architecture are covered in this guide