Login  Register

move temp file

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

move temp file

big
442 posts
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
| More
Print post
Permalink

Re: move temp file

ErmanArslansOracleBlog
Administrator
5727 posts