How to rename a datafile in windows
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to rename a datafile in windows

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    How to rename a datafile in windows

    hi,

    I take the TBS offiline and when it try to rename the file at OS level, it says File is used by other program or user.

    D:\ORA\product\oradata\orcl>rename SYSAUX03.DBF SYSAUX01.DBF
    The process cannot access the file because it is being used by another process.


    Thx.
    Last edited by bang_dba; 12-03-2007 at 12:11 AM.
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  2. #2
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Didi u check if u have this file already existing or not?
    http://www.perf-engg.com
    A performance engineering forum

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you will need to copy the file, cant move in windows while it is still open

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width