Monday, August 22, 2016

How to rename datafiles in Oracle 11g

[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 sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 22 09:48:56 2016 Copyright...

Tuesday, August 2, 2016