On 7/25/07, Vivek J. Patankar list307@gmail.com wrote:
Hozefa Motiwala wrote:
We have installed Oracle 10gR2 with patch updated to 10.2.3 on a RHEL 4 , update 4. Some how the dba made a mistake to install the database file on / folder instead of the /var folder which had loads of disk space. Now the / folder is used upto 100% of the disk space. Can creating a softlink to /var/database/ help in this case. Is there any other way to resolve this problem
Assuming this is a system datafile, you can do this to move it to /var:
SQL> shu abort; ORACLE instance shut down.
$ mv /old-location/system.dbf /var/system.dbf
$sqlplus '/ as sysdba'
SQL> startup mount; ORACLE instance started.
Total System Global Area 97588504 bytes Fixed Size 451864 bytes Variable Size 46137344 bytes Database Buffers 50331648 bytes Redo Buffers 667648 bytes Database mounted. SQL> alter database rename 2 file '/old-location/system.dbf' 3 to '/var/system.dbf';
Database altered.
SQL> alter database open;
Database opened.
Verify the result.
SQL> select name from v$datafile;
NAME ------------------------ /var/system.dbf
Regards, NMK.