How to manage Temporary Table space in Oracle Database

                                 Temporary tablespace 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 TEMPORARY TABLESPACE … Read more