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"
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.
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 -
you guys are the best!
I'm glad I found this forum.