move temp file

Posted by big on Apr 17, 2023; 5:58pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/move-temp-file-tp11805.html

Hi,
On 19.9 C on AIX

can I move temp file as follows:

sqlplus / as sysdba

SQL> ALTER SESSION SET container="mypdb";
alter database tempfile /u01/sgbd/mypdb/temp0001.dbf offline;
by OS mv commande line:
mv /u01/sgbd/mypdb/temp0001.dbf /u01/sgbd/mypdb/disktemp01/
SQL> alter database rename file /u01/sgbd/mypdb/temp0001.dbf /u01/sgbd/mypdb/disktemp01/temp0001.dbf

SQL> alter database tempfile /u01/sgbd/mypdb//disktemp01/temp0001.dbf online;


Thanks and regards.