7 Replies Latest reply on Apr 14, 2014 2:03 AM by Hemant K Chitale

    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:


      ORA-27037: unable to obtain file status

      Linux Error: 2: No such file or directory

      Additional information: 3