switching datafiles that are used

I'm running 9i on a Unix AIX 5 system. I have a logical volume that is getting full and have created a new volume that I want to start using.

I want to create a datafile, on the new disk, for each datafile that existed on the old disk. After doing this how can I insure that I wont write to the old disk anymore?

I have turned off the autoextend on those old datafiles, is that enough to get them to quite writing to the old files when they have used what has been allocated already? I'm also going to resize the old datafiles after I have completed the creation of the new ones. Received on Thu Jan 05 2006 - 13:44:17 CST