Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about LMT
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi Luc,
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>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:
10.0pt;font-family:Arial;color:navy'>
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>Cheers,
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>g.
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>
<span
lang=EN-US style='font-size:10.0pt;font-family:Tahoma;mso-ansi-language:EN-US'>-----Original
Message-----
From: DEMANCHE Luc (Cetelem)
[mailto:Luc.Demanche_at_cetelem.fr]
Sent: 13 June 2001 12:05
To: Multiple recipients of list
ORACLE-L
Subject: Question about LMT
<font size=3
face="Times New Roman">
<span style='font-size:
10.0pt;font-family:Arial'>Hi all,
<span style='font-size:
10.0pt;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:
10.0pt;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:
10.0pt;font-family:Arial'>Example : datafile
size = 500M + 64 Kb = 512064 Kb <span
<span style='font-size:
10.0pt;font-family:Arial'>TIA
<span style='font-size:
10.0pt;font-family:Arial'>-----------------Luc
![]() |
![]() |