How to manage Temporary Tablespace in Oracle Database
In this post we learn how to manage Temporary Table space in Oracle Database. | Temporary tablespaces are providing temporary space for database sort operations and for storing global temporary tables. To Create user with default tablespace and temporary tablespace. SQL> CREATE USER scott DEFAULT TABLESPACE data TEMPORARY TABLESPACE temp; SQL> ALTER USER scott … Read more