Re: resize datafile problem

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_at_yahoo.com>
To: oracle-l_at_freelists.org; peter.sharman_at_oracle.com
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





 
____________________________________________________________________________________
Sponsored Link

Mortgage rates near 39yr lows. $510k for $1,698/mo. 
Calculate new payment! www.LowerMyBills.com/lre

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