Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> switching datafiles that are used

switching datafiles that are used

From: <balvey_at_comcast.net>
Date: 5 Jan 2006 11:44:17 -0800
Message-ID: <1136490257.824608.327450@g43g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US