system tablespace --
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: system tablespace --

  1. #1
    Join Date
    Jan 2001
    Posts
    60
    Hi

    I created a user by

    create user xy identified by xy (and i didnt mention in what tablespace it should get creaed ).
    I think it gets created in system tablespace,can i drop that user and recreate it.

    I want to know exact syntax

    Thanks
    lnr
    html code is off

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    just alter users's default tablespace to another tablespace you want, you dont have to drop the user unless that user has already objects created in tablespace system
    you have all the commands in Oracle Docs

  3. #3
    Join Date
    Aug 2000
    Posts
    462
    alter user xy default tablespace users;

  4. #4
    Join Date
    Mar 2001
    Posts
    131

    Thumbs up

    Yes, It is right that you don't have to drop the user but you can always alter user and change its characteristics.......but any time u create a user you have to have practice of defining atleast mandetory part of it.....it's like this,

    Create user xyz identified by xyz
    default tablespace abc
    temporary tablespace temp..............

  5. #5
    Join Date
    Feb 2001
    Posts
    123
    As Upeshp says, don't forget to alter the users temporary tablespace as well as the default tablespace - disk sorts taking place in the system tablespace is a *bad* thing...

    HTH

    David.

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