DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: alter user to a different tablespace

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hi .. I have a user created and is assigned to system as temporary tablespace.. I want the user to be made into temp as temporary tablespace.. what is the sql command??
    Thanks,...

  2. #2
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    alter user x temporary tablespace temp;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width