default tablespace for user
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: default tablespace for user

  1. #1
    Join Date
    May 2001
    Posts
    285
    Hi,

    I know it's a good practice to assign a default tablespace when creating a new user 'cause otherwise every object created for that user will be stored in SYSTEM tablespace. However, if I want to store all user tables into USER_TABLE tablespace and all user indexes into USER_INDX tablespace, then which tablespace shall I assigned to the user as the default one? Or I have to explicitly put tablespace clause at the end of the table build script?

    Also, if the datafile gets too big, it will be good to use 2 smaller datafiles instead of 1 big file to improve performance (or make backup faster?). So how big is too big? i.e. when should we begin to think about split it?

    Thanks!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    you assign data always then specify tablespace clause in index creation

    about splitting files it depends on how many disks you have, if you have one only then there is no point splitting them unless you hit the size limit

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    USER_TABLE should be the default tablespace for the users. Remember that TEMP tablespace should also be given for all new users.

    File size: It depends upon the OS. In general keep them below 2 GB, if your OS is 32 bit.

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