Printable View
Would you guys check this for me?
I need to know the names of temporary and default tablespaces for users sys and system.
I have system using system as default tablespace and sysTEMP as temporary tablespace. On another hand my sys
is using system tablespace for both.
Thank you.
I always configure SYS with the default tablespace of SYSTEM and temporary tablespace as TEMP. SYSTEM usually has a default tablespace of TOOLS and temporary tablespace as TEMP.
The reason I do this is because I have some tools that create tables on the fly as system. I don't want those tables in the system tablespace.