When creating a user/schema to hold external application data, what are best practices for the tablespaces that the user is defaulted to?
Should the user created be defaulted to the
USER tablespace for the default tablespace? Does this hold true for the
TEMP tablespace? Or should this user have a separate default and temp tablespaces created apart from the
SYSTEM user tablespaces to hold the application data?
I tried looking for any indication of this in the Oracle documentation, but wasn't able to find anything close to what I was looking for - apologies if this is subjective in nature.