Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: resize datafile problem

Re: resize datafile problem

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Wed, 22 Nov 2006 02:12:25 -0800 (PST)
Message-ID: <20061122101225.55321.qmail@web52910.mail.yahoo.com>

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
Received on Wed Nov 22 2006 - 04:12:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US