The two methods explained in the note require the database to be in "MOUNT" or the tablespace to be offline. I need to this while the database is available. On Sat, Sep 18, 2010 at 11:28 PM, Leyi Zhang (Kamus) <kamusis@xxxxxxxxx>wrote: > Hi > > Maybe you wanna check MOS Note: How to move a datafile from ASM to the > file system [ID 390416.1] > > -- > Kamus <kamusis@xxxxxxxxx> > > Visit my blog for more : http://www.dbform.com > Join ACOUG: http://www.acoug.org > > > > On Sun, Sep 19, 2010 at 12:52 AM, Peter Hitchman <pjhoraclel@xxxxxxxxx> > wrote: > > Hi, > > I second that, use the rman copy command and then the switch command. I > have > > not used the asmcmd cp command in 11.2, but my use of it in 11.1 has been > > very negative. > > > > Regards > > Pete > > > -- > //www.freelists.org/webpage/oracle-l > > >