Moving the datafiles to new location in oracle

Step 1: shut down the database

Sql> shutdown immediate;

Step : start database in mount mode

Sql> alter database mount;

Step :rename/relocate the datafiles to new location;

mv  /db/EDEV/db/apps_st/data/APPS_OMO02.dbf  /db2/EDEV/db/apps_st/data/APPS_OMO02.dbf

mv  /db/EDEV/db/apps_st/data/APPS_TS_QUEUES02.dbf /db2/EDEV/db/apps_st/data/APPS_TS_QUEUES02.dbf

step 4: rename file within database;

Sql> alter database rename file ‘/db/EDEV/db/apps_st/data/APPS_OMO02.dbf ‘ to ‘/db2/EDEV/db/apps_st/data/APPS_OMO02.dbf’;

Step5 :alter database open;