| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about LMT
Also
note, if you try resizing a datafile smaller than it has ever been, it will
complain.
<FONT face=Arial color=#0000ff
size=2>
In
other words, if you have a 500M datafile and used 400M, then drop 300M, you
cannot resize it to 100M.
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence <FONT
face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS"
size=2>Fuelspot
<FONT face=Tahoma
size=2>-----Original Message-----From: Guy Hammond
[mailto:guy.hammond_at_avt.co.uk]Sent: Wednesday, June 13, 2001 8:15
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Question about LMT
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hi
Luc,
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">If you try to resize
a datafile to a size below that of the actual data it contains, Oracle will
warn you. Try setting Autoextend on if you're worried about running out of
space on a recently shrunk file; looking at your numbers I'm guessing that you
have plenty of space on the disk. As long as you keep an eye on the datafile
size, it will be fine.
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Cheers,
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">g.
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
<SPAN
lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma; mso-ansi-language: EN-US">-----Original
Message-----From: DEMANCHE
Luc (Cetelem) [mailto:Luc.Demanche_at_cetelem.fr] <SPAN
style="FONT-WEIGHT: bold">Sent: 13 June 2001 12:05<SPAN
style="FONT-WEIGHT: bold">To: Multiple recipients of list
ORACLE-LSubject: Question
about LMT
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi all,
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I created a tablespace in
LMT. I created all my datafiles with an extra 64 Kb for the bitmap
index.
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">My question is : If I want to
resize my datafile, do I have to keep this extra 64 Kb ?
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Example :
datafile size = 500M + 64 Kb = 512064 Kb <SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">-----------------
 |
 |