balvey_at_comcast.net wrote:
> I don't want to copy. I want new datafiles without losing the old ones.
> They still need to be read but any new data needs to be written to my
> new disk.
>
> Basically I need to know if I turn off autoextend on a datafile will
> the new datafiles start to be used when the old fills up.
>
1) alter each existing datafile so autoextend is off.
2) alter each datafile so that it is resized to the end of the HWM.
That is, resize it to release back to the OS any free space beyond the
end of the last used extent.
3) add a datafile for each tablespace on the new disk volume.
Done.
Received on Fri Jan 06 2006 - 13:34:24 CST
