Skip to Main Content
Forums

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!

alter user default tablespace and temporary tablespace

760019Dec 29 2010 — edited Dec 29 2010
Hi guru,

target : to ensure that users don't have the SYSTEM tablespace as their TEMPORARY or DEFAULT tablespace

scenario :
user default tablespace temporary tablespace
-------- ------------------------------ ---------------------------
xxyym system system

Question: How to alter user ?

tq
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2011
Added on Dec 29 2010
#dba, #general-database-discussions
2 comments
109,379 views