Re: resize datafile problem

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 22 Nov 2006 23:26:43 +0800
Message-Id: <7.0.1.0.0.20061122232422.01ba8848@singnet.com.sg>

You can issue ALTER DATABASE DATAFILE '<filename>' AUTOEXTEND ON NEXT 10M MAXSIZE 2000M;
or just ALTER DATABASE ... AUTOEXTEND OFF; and ALTER DATABASE .. RESIZE 2000M;

As long as the file does not contain data beyond the 2000M mark (in fact your file hasn't yet grown beyond the 2000M mark) , you can resize it down to 2000M.

Hemant

At 06:12 PM Wednesday, Kean Jacinta wrote:
>Sorry , there are some mistake . I want to change :
>
>MAXBYTES MAXBLOCKS Increment BY
>34359721984 4194302 1
>
>To This instead :
>
>MAXBYTES MAXBLOCKS Increment BY
>2097152000 256000 2560
>

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 22 2006 - 09:26:43 CST