Modify Oracle's DataFile file name

Today to increase the data file, the database file name more than one point, although it can be used, but in the operating system to see the file but feel very uncomfortable, check some data, modify the method summarized as follows:

1. Close the database

Sqlplus/nolog

SHUTDOWN;

2. Renaming data files in the operating system

3. Loading the database, modifying the database file name in Oracle

Sqlplus/nolog

START MOUNT;

ALTER DATABASE RENAME FILE ' old_filename ' to ' new_filename ';

4. Open the data to check if the modification was successful

ALTER DATABASE OPEN;

SELECT NAME, STATUS from V$datafile;