Re: resize datafile problem
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: jacintakean@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 22 Nov 2006 23:26:43 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
