hi: There is no online way to move datafiles. But you can use RMAN "copy file" to minimize the downtime. 1. use RMAN to copy datafiles 2. take datafiles offline 3. rename to new path 4. RECOVER DATAFILE 5. bring the datafile online. On Nov 8, 2007 5:14 AM, Dhimant Patel <drp4kri@xxxxxxxxx> wrote: > Hi, > > I need to move certain datafiles to another partition which is recently made > available. I can move/rename files after taking them offline - although I > would prefer if RMAN can do this while the file is online! > > Is there such way of moving files? A quick look at RMAN commands doesn't > offer any clue. > > -Thanks, > DP. -- Eagle Fan Oracle DBA -- //www.freelists.org/webpage/oracle-l