Skip to Main Content

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

Question and Answer

Connor McDonald

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)

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

Comments

A reader, June 17, 2020 - 2:44 pm UTC


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Multitenant

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