On 7/25/07, Vivek J. Patankar <[EMAIL PROTECTED]> 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. -- http://mm.glug-bom.org/mailman/listinfo/linuxers
