Re: resize datafile problem
- From: Kean Jacinta <jacintakean@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, peter.sharman@xxxxxxxxxx
- Date: Wed, 22 Nov 2006 02:12:25 -0800 (PST)
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
____________________________________________________________________________________
Sponsored Link
Mortgage rates near 39yr lows. $510k for $1,698/mo.
Calculate new payment! www.LowerMyBills.com/lre
Other related posts:
