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

Thread: temp or user ?

  1. #1
    Join Date
    Feb 2001
    Posts
    51

    Red face

    Hello, its me again.

    I have created a tablespace of temp and users.

    I created couple users with default tablespace users
    and temporary tablespace temp.

    when these users add an object ie. tables etc.

    where will the data reside? on "users" right?

    or do I need to create another tablespace call "data"

    explain please.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Yes, USERS. If your user creates an object without explicitly specifiying a tablespace, it will get created in their DEFAULT tablespace. In this case, USERS.
    Jeff Hunter

  3. #3
    Join Date
    Mar 2001
    Posts
    3
    Yep.

    If a user's default tablespace is "USERS" Oracle will create objects (tables etc.) in that tablespace.

    TEMP will be used for temporary tables etc. Oracle create while sorting results of the user's query etc.

    Make sure your user has "create session" and enough privileges on USERS to do what they want.

    all the best -
    Pete.

  4. #4
    Join Date
    Feb 2001
    Posts
    51

    Thumbs up


    you guys are the best!

    I'm glad I found this forum.

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