|
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.
|