How to Create Temporary Tablespace in Oracle
- 1). Log in to the Oracle database.
- 2). Type "use db_name;" into the query manager window, where "db_name" is the name of the database where you want to create the temporary tablespace, and press "Enter."
- 3). Type "make table_tmp 'tablename';" into the query manager window, where "tablename" is the name of the temporary table you want to create.
- 4). Press "Enter" to create the temporary tablespace.
Source...