Friday, April 9, 2010

Moving or Renaming oracle datafiles from one drive to another drive

Moving or Renaming oracle datafiles from one drive to another drive
==================================================================

SQL> conn sys@db11g as sysdba
Enter password:
Connected.
SQL>
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL>host move C:\oracle11G\app\era-1\oradata\db11g\SYSAUX01.DBF
E:\oracle11g_datafile\SYSAUX01.DBF;

SQL> startup mount
ORACLE instance started.

Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 176161684 bytes
Database Buffers 352321536 bytes
Redo Buffers 5844992 bytes
Database mounted.


SQL> alter database rename file 'C:\oracle11G\app\era-1\oradata\db11g\SYSAUX01.DBF'
2 to 'E:\oracle11g_datafile\SYSAUX01.DBF';

Database altered.

SQL> alter database open
2 ;

Database altered.

SQL>

No comments: