Database Administration (MOSC)

MOSC Banner

How to remove very irritating LOCAL Temporary tablespace in 12.2 or 19.18

hi, afternoon everyone.

Made a big mistake and implemented Local Temporary tablespaces before realizing the implications, namely, that as they are BIGFILES they are hard to manage.

Smallfile temporary tablespace TEMP is the default temporary tablespace

Bigfile Local temporary tablespace LOCAL_TEMP is the default local temporary tablespace

I have reset all schemas previously using LOCAL_TEMP as the local temporary tablespace to now use TEMP, so all users will be using TEMP and TEMP instead of TEMP and LOCAL_TEMP.

The PROBLEM and it's a big one. SOMEHOW i managed to set the off-limits schema XS$NULL to use LOCAL_TEMP, but now i cannot reset this schema to use just TEMP.

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