Re: Changing datafile size.

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 21 Dec 2005 09:28:23 -0800
Message-ID: <1135186087.637118@jetspin.drizzle.com>

hub wrote:
> Hello,
>
> I have tablespace that consist of two datafiles. One is almost full,
> secondary is empty. I want to decrease size of the first file. Will
> Oracle automatically move data to the empty file?
>
> Thanks
> hub

No. And it is impossible to decrease the size of the first datafile.

What is it you are actually trying to accomplish.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Wed Dec 21 2005 - 11:28:23 CST