Re: resize datafile problem
- From: Jason Heinrich <jheinrich@xxxxxxxx>
- To: <jacintakean@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Nov 2006 08:59:48 -0600
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&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@xxxxxxxx
Other related posts:
