7 Replies Latest reply: Apr 13, 2014 9:03 PM by Hemant K Chitale RSS

    Relocating all physical files

    GTS (DBA)

      Hi All ;

       

      I am trying to relocate  my datafiles from one path to another path but i am getting error.

      i cant resolve it.

       

      SQL> alter database rename file

        2  '/u01/app/oracle/product/10.2.0/db_1/oradata/db4/system01.dbf' to '/u01/app/oracle/oradata/system01.dbf';

      alter database rename file

      *

      ERROR at line 1:

      ORA-01511: error in renaming log/data files

      ORA-01141: error renaming data file 1 - new file

      '/u01/app/oracle/oradata/system01.dbf' not found

      ORA-01110: data file 1:

      '/u01/app/oracle/product/10.2.0/db_1/oradata/db4/system01.dbf'

      ORA-27037: unable to obtain file status

      Linux Error: 2: No such file or directory

      Additional information: 3