watergrinder
MIS
Hello, we have a datafile of initial size 500MB on a 8i DMT. Auto increment of 500MB. Max size is 2GB. Can we increase initial size to 1GB? How complicated is the procedure?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
datafile increase initial size
- Thread starter watergrinder
- Start date
- Status
SantaMufasa
Technical User
Grinder,
Not complicated at all:
Advise us of your success.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA @ 21:21 (10Jun04) UTC (aka "GMT" and "Zulu"), 14:21 (10Jun04) Mountain Time)
Not complicated at all:
Code:
ALTER DATABASE DATAFILE '<file_name>' RESIZE 2000M;Advise us of your success.
Mufasa(aka Dave of Sandy, Utah, USA @ 21:21 (10Jun04) UTC (aka "GMT" and "Zulu"), 14:21 (10Jun04) Mountain Time)
SantaMufasa
Technical User
Grinder,
Sorry, I was going full-sized (2GB) right away; should have read "...RESIZE 1000M" for a 1GB target initial size.
Mufasa
(aka Dave of Sandy, Utah, USA @ 21:24 (10Jun04) UTC (aka "GMT" and "Zulu"), 14:24 (10Jun04) Mountain Time)
Sorry, I was going full-sized (2GB) right away; should have read "...RESIZE 1000M" for a 1GB target initial size.
Mufasa(aka Dave of Sandy, Utah, USA @ 21:24 (10Jun04) UTC (aka "GMT" and "Zulu"), 14:24 (10Jun04) Mountain Time)
- Thread starter
- #4
watergrinder
MIS
Thanks Santa. I will let you know once done.
- Status
Similar threads
- Locked
- Question
- Locked
- Question