Re: resize datafile problem

First, your datafile is already 2000M, so you don¹t need to resize it:
2097152000B / 1024 = 2048000K / 1024 = 2000M

Second, since the datafile is already at its max size, why bother turning
autoextend on at all?
alter database datafile '/oracle/sub/datafile4/psub_1/psub_datafile1.dbf'
AUTOEXTEND OFF;

If you do want autoextend on for whatever reason, you can change its maxsize
without resizing the datafile:
alter database datafile '/oracle/sub/datafile4/psub_1/psub_datafile1.dbf'
AUTOEXTEND ON NEXT 20M MAXSIZE 2000M;


On 11/22/06 4:12 AM, 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
> 
> Is this possible ?
> 
> THank You
> 
> 
> 
> ----- Original Message ----
> From: Kean Jacinta <jacintakean@xxxxxxxxx>
> To: oracle-l@xxxxxxxxxxxxx; peter.sharman@xxxxxxxxxx
> Sent: Wednesday, November 22, 2006 3:56:12 PM
> Subject: resize datafile problem
> 
> Hi ,
> 
> I have create a datafile psub_datafile1  in PSUB tablespace . Apparently i set
> the datafile to unlimited  and increment_by = 1.  The database has use this
> datafile.
> Would it be possible to resize my datafile to this :
> 
> alter database datafile '/oracle/sub/datafile4/psub_1/psub_datafile1.dbf'
> resize 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 2000M
> 
> I an afraid this command might corrupt the datafile and endup losing data. I
> queryt this
> 
> SELECT FILE#, STATUS, ENABLED, CHECKPOINT_CHANGE#, BYTES, CREATE_BYTES, NAME
> FROM V$DATAFILE;
> 
> and relize that the BYTES and CREATED_BYTES for this datafile  is having the
> same value 
> 
> BYTES                CREATED_BYTES
> 2097152000   2097152000
> 
> Pls teach me and give me some opinion what can i do .
> 
> thank in advance.
> 
> JK
> 
> 
> Sponsored Link
> 
> Mortgage rates as low as 4.625% - $150,000 loan for $579 a month. Intro-*Terms
> <https://www2.nextag.com/goto.jsp?product=100000035&amp;url=%2fst.jsp&amp;tm=y
> &amp;search=b_rate150k&amp;s=3968&amp;p=5035&amp;disc=y&amp;vers=722>
> 
> 
> 
> Sponsored Link
> 
> Rates near 39yr lows. $510,000 Loan for $1698/mo -   Calculate new house
> payment 
> <http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9137-16419&moid=4119>



---------------
Jason Heinrich
Oracle Database Administrator
Pensacola Christian College
(850) 478-8496 x2509
jheinrich@xxxxxxxx

Other related posts: