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>
Everything Changes
2 weeks ago
No comments:
Post a Comment