Change Default Temporary Tablespace in Oracle

Being Oracle DBA we all are well known about the tablespace. Oracle RDBMS have multiple kinds of a tablespace with a different kind of purpose. We are going to have look on steps use for “Change Default Temporary Tablespace”. Check the current default temporary tablespace SQL> column property_value format a25 SQL> SELECT property_name,property_value FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’; […]

Read More