Shutdown the database.
Rename the physical file on the OS.
Start the database in mount mode.
Issue the ALTER DATABASE RENAME FILE command to rename the file within the Oracle dictionary.
Open the database. SQL> SELECT name FROM v$datafile;
NAME
--------------------------------------------------------------------------------
/u02/MJBDB/oradata/system.dbf
/u04/MJBDB/oradata/undotbs01.dbf
/u04/MJBDB/oradata/undotbs02.dbf
/u02/MJBDB/oradata/aud01.dbf
/u27/MJBDB/oradata/ts_dyn_agg_data1.dbf
/u02/MJBDB/oradata/drsys01.dbf
/u02/MJBDB/oradata/indx01.dbf
/u02/MJBDB/oradata/developers.dbf
/u12/MJBDB/oradata/ ts_mjbagg_idx_04.dbf
The following SQL*Plus output shows how this is done. SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down. SQL> HOST MV /u12/MJBDB/oradata/ ts_mjbagg_idx_04.dbf /u12/MJBDB/oradata/ts_mjbagg_idx_04.dbf
*** removed TAB character.
SQL> STARTUP MOUNT
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 787968 bytes
Variable Size 61864448 bytes
Database Buffers 104857600 bytes
Redo Buffers 262144 bytes
Database mounted.
SQL>ALTER
DATABASE RENAME FILE ‘/u12/MJBDB/oradata/ ts_mjbagg_idx_04.dbf' TO
‘/u12/MJBDB/oradata/ts_mjbagg_idx_04.dbf’; Database altered.
SQL> ALTER DATABASE OPEN;
Database altered.
SQL>Repeating the initial query shows that the the datafile has been renamed in the data dictionary.
SQL> SELECT name FROM v$datafile;
NAME--------------------------------------------------------------------------------
/u02/MJBDB/oradata/system.dbf
/u04/MJBDB/oradata/undotbs01.dbf
/u04/MJBDB/oradata/undotbs02.dbf
/u02/MJBDB/oradata/aud01.dbf
/u27/MJBDB/oradata/ts_dyn_agg_data1.dbf
/u02/MJBDB/oradata/drsys01.dbf
/u02/MJBDB/oradata/indx01.dbf
/u02/MJBDB/oradata/developers.dbf
/u12/MJBDB/oradata/ts_mjbagg_idx_04.dbf’
| 