Database Administration (MOSC)

MOSC Banner

question about temporary tablespace group

edited Aug 7, 2013 5:49AM in Database Administration (MOSC) 9 commentsAnswered
Hi Everyone,
If I have a tablespace group consisting of three temporary tablespaces, and if a user default tablespace is one of the temporary tablespace, instead of the group, will the use able to use the other temp tablespaces in the group if its default temp tablespace is used up?

If I change all user default temp tablespace to the group, will that eleminated the need to balance the space for the three tablespaces until all of them used up?

Thanks.
Yinhai

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