Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Switch to new temporary tablespace

672680Dec 19 2010 — edited Dec 20 2010

How can I switch to a newly created temporary tablespace?
anyone could help provide the detailed steps of doing this?

Also, if I can see two temporary tablespaces from dba_tablespaces view, then how can I know which one is in use?
NOte: these two temporary tablespace do not belong to same tablespace group.

This post has been answered by sb92075 on Dec 19 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 17 2011

Added on Dec 19 2010

#general-database-discussions

5 comments

26,060 views