Clever Geek Handbook

Oracle temp tablepace alter statement

What's wrong with my request? I looked here but couldn't solve the problem.

SQL> CREATE TEMPORARY TABLESPACE TEMPRM;

The tablespace has been created.

SQL> ALTER  TABLESPACE  TEMPRM ADD DATAFILE   '+TEMPDATA/rm/datafile/TEMPRM_temp01.dbf';
ALTER  TABLESPACE  TEMPRM ADD DATAFILE   '+TEMPDATA/rm/datafile/TEMPRM_temp01.dbf'
*
ERROR at line 1: ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
+3


source to share


1 answer


The temporary tablespace is made up of tempfiles, not data files, so:



ALTER  TABLESPACE TEMPRM ADD TEMPFILE '+TEMPDATA/rm/datafile/TEMPRM_temp01.dbf' SIZE 2G;
----------------------------- Here -^
+6


source






More articles:


All Articles