Re: resize datafile problem

From: Jason Heinrich <jheinrich_at_pcci.edu>
Date: Wed, 22 Nov 2006 08:59:48 -0600
Message-ID: <C189C204.1715A%jheinrich@pcci.edu>

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_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
> <https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y
> &search=b_rate150k&s=3968&p=5035&disc=y&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_at_pcci.edu

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

Received on Wed Nov 22 2006 - 08:59:48 CST