Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about LMT

RE: Question about LMT

From: Guy Hammond <guy.hammond_at_avt.co.uk>
Date: Wed, 13 Jun 2001 04:49:35 -0700
Message-ID: <F001.0032744A.20010613041522@fatcity.com>

<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

style='font-size:10.0pt;font-family:Arial'>resize to 50M   = 51200 or 51264 Kb

<span style='font-size:

10.0pt;font-family:Arial'>TIA

<span style='font-size:

10.0pt;font-family:Arial'>----------------- 
Luc
Demanche
<span style='font-family:Arial;font-weight:bold;
font-style:italic'>CETELEM
Tél.:
01-46-39-14-49
Fax :
01-46-39-59-88 Received on Wed Jun 13 2001 - 06:49:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US