database tempfile

How Do I Change The Default Temporary Tablespace In Oracle 12c?

by

How Do I Change The Default Temporary Tablespace In Oracle 12c? To set the default temporary tablespace in Oracle, you can run the following ALTER DATABASE statement: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE tbs_temp_01; This will update the default temporary tablespace to use the tbs_temp_01 tablespace. How do I find the default temp tablespace in Oracle