Thanks for the question, RKB.
Asked: February 25, 2020 - 6:11 pm UTC
Last updated: February 26, 2020 - 1:41 am UTC
Version: 18.3.0.0.0
Viewed 1000+ 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 Connor 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
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment