move temp file

classic Classic list List threaded Threaded
2 messages Options
big
Reply | Threaded
Open this post in threaded view
|

move temp file

big
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.
Reply | Threaded
Open this post in threaded view
|

Re: move temp file

ErmanArslansOracleBlog
Administrator