Rename or Move Oracle datafiles

One of my juinor dba created the files without extension and I really dont like that, also I wanted to blog about this from quite sometime so here it goes: Start Sqlplus and logon as sysdba [oracle@**** ****]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 26 13:20:34 2011 Copyright (c) 1982, 2009, Oracle.  All rights reserved. SQL> conn …