RE: Question about LMT

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Wed, 13 Jun 2001 06:27:46 -0700
Message-ID: <F001.00327766.20010613061120@fatcity.com>

If you
plan on still using LMT and want an even extent at the end.  
"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: DEMANCHE Luc (Cetelem)   [mailto:Luc.Demanche_at_cetelem.fr]Sent: Wednesday, June 13, 2001 8:56   AMTo: Multiple recipients of list ORACLE-LSubject: 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="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">resize to 50M   =     51200 or 51264 Kb
<SPAN

    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">TIA

<SPAN

    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">----------------- 

<SPAN

    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Luc Demanche
<SPAN

    style="FONT-WEIGHT: bold; FONT-STYLE: italic; FONT-FAMILY: Arial">CETELEM
<SPAN

    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Tél.: 
    01-46-39-14-49 <SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Fax : 
    01-46-39-59-88 

Received on Wed Jun 13 2001 - 08:27:46 CDT