Tablespace for new Oracle user 1

[henryz]

Hi,

Here is a question. When I create a new user in Oracle database, I normally assign "SYSAUX" as its default Tablespace, and "TEMP" as its Temporary Tablespace. Is it a good practice? Any performance effect? are there any ground rules when assigning Tablespaces to new users?

Thanks,
Henry

 

[stefanhei]

SYSAUX is for db-internal objects, so it's no good practice to assign it as default tablespace to normal users. Better use tablespace USERS.
Ground rule: never assign SYSTEM or SYSAUX as default or temporary tablespace to users ;-)

Stefan