---------------------
sqlplus /as sysdba
alter tablespace INDEX16 offline;
!mv /data1/TTS/oracle/app/oracle/oradata/TTS/index16*.dbf /data2/TTS/oracle/app/oracle/oradata/TTS/
alter tablespace INDEX16 rename datafile '/data1/TTS/oracle/app/oracle/oradata/TTS/index16a.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16a.dbf';
alter tablespace INDEX16 rename datafile '/data1/TTS/oracle/app/oracle/oradata/TTS/index16b.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16b.dbf';
alter tablespace INDEX16 rename datafile '/data1/TTS/oracle/app/oracle/oradata/TTS/index16c.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16c.dbf';
alter tablespace INDEX16 rename datafile '/data1/TTS/oracle/app/oracle/oradata/TTS/index16d.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16d.dbf';
alter tablespace INDEX16 rename datafile '/data1/TTS/oracle/app/oracle/oradata/TTS/index16e.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16e.dbf';
alter tablespace INDEX16 rename datafile '/data1/TTS/oracle/app/oracle/oradata/TTS/index16f.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16f.dbf';
alter tablespace INDEX16 online;
Moving Datafiles while the Instance is Mounted
sqlplus "/ as sysdba"
shutdown immediate
!mv /data1/TTS/oracle/app/oracle/oradata/TTS/index16* /data2/TTS/oracle/app/oracle/oradata/TTS/
startup mount
alter database rename file '/data1/TTS/oracle/app/oracle/oradata/TTS/index16a.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16a.dbf';
.... (and for the other datafiles)
Do not disconnect after this step. Stay logged in and proceed to open the database!
alter database open;
Hi,
your article so informative and i have cleared all of my doubts.
your way of explanation is awesome thank you for sharing useful information.
regards,
Oracle Fusion HCM Training
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.
oracle fusion financials online training