[Problem]
I want to rename datafile E:\ORACLE\VNPT\DATAFILE\O1_MF_EXAMPLE_CVNONK37_.DBF to E:\ORACLE\VNPT\DATAFILE\EXAMPLE.DBF[FIX]
D:\Users\Administrator>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 22 09:48:56 2016
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
E:\ORACLE\VNPT\DATAFILE\O1_MF_SYSTEM_CVNOJMJ1_.DBF
E:\ORACLE\VNPT\DATAFILE\O1_MF_SYSAUX_CVNOJXF6_.DBF
E:\ORACLE\VNPT\DATAFILE\O1_MF_UNDOTBS1_CVNOK3LH_.DBF
E:\ORACLE\VNPT\DATAFILE\O1_MF_USERS_CVNOK42T_.DBF
E:\ORACLE\VNPT\DATAFILE\O1_MF_EXAMPLE_CVNONK37_.DBF
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> host move E:\ORACLE\VNPT\DATAFILE\O1_MF_EXAMPLE_CVNONK37_.DBF E:\ORACLE\VNP
T\DATAFILE\EXAMPLE.DBF;
1 file(s) moved.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 436208080 bytes
Database Buffers 92274688 bytes
Redo Buffers 5804032 bytes
Database mounted.
SQL> alter database rename file 'E:\ORACLE\VNPT\DATAFILE\O1_MF_EXAMPLE_CVNONK37_
.DBF' to 'E:\ORACLE\VNPT\DATAFILE\EXAMPLE.DBF';
Database altered.
SQL> alter database open;
Database altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
E:\ORACLE\VNPT\DATAFILE\O1_MF_SYSTEM_CVNOJMJ1_.DBF
E:\ORACLE\VNPT\DATAFILE\O1_MF_SYSAUX_CVNOJXF6_.DBF
E:\ORACLE\VNPT\DATAFILE\O1_MF_UNDOTBS1_CVNOK3LH_.DBF
E:\ORACLE\VNPT\DATAFILE\O1_MF_USERS_CVNOK42T_.DBF
E:\ORACLE\VNPT\DATAFILE\EXAMPLE.DBF
SQL>
