| 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
Hi
Guy,
<SPAN
class=964174611-13062001>
My
question is only for the extra 64 Kb. When we created datafiles, we added
64 Kb for the last extend (because bitmap index need only 64
Kb).
Is it
important to keep this extra 64 Kb when we want to resize the
datafiles.
<SPAN
class=964174611-13062001>
<SPAN
class=964174611-13062001>Luc
-----Message
d'origine-----De: Guy Hammond
[mailto:guy.hammond_at_avt.co.uk]Date: Wednesday, June 13, 2001 2:15
PMÀ: Multiple recipients of list ORACLE-LObjet: RE:
Question about LMT
<SPAN
style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Hi
Luc,
<SPAN
style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">
<SPAN
style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">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="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">
<SPAN
style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Cheers,
<SPAN
style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">
<SPAN
style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">g.
<SPAN
style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">
<SPAN
lang=EN-US
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt; 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-FAMILY: Arial; FONT-SIZE: 10pt">Hi all,
<SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">I created a tablespace in
LMT. I created all my datafiles with an extra 64 Kb for the bitmap
index.
<SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">My question is : If I want to
resize my datafile, do I have to keep this extra 64 Kb ?
<SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Example :
datafile size = 500M + 64 Kb = 512064 Kb <SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">-----------------
 |
 |