Database Administration (MOSC)

MOSC Banner

Shared temporary tablespace in multi-tenant DB with silent install

I am running a silent, multitenant database creation. Initially I tried using the General_Purpose.dbc template, but the temporary tablespace is named TEMP and I need the temporary tablespace to be named TEMPORARY. After creating the container database I try to create a new temporary tablespace named temporary, set it to default temp tablespace, then drop the original temporary tablespace named TEMP. However, when I check pluggable databases they still create using a temporary tablespace named TEMP. So I'm confused as to why the pluggable databases are not sharing the container temporary tablespace OR why are new pluggable databases still creating

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center