RE: Question about LMT

[Guy Hammond]

Title: Question about LMT

Hi Luc,   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.   Cheers,   g.   -----Original Message----- From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]] Sent: 13 June 2001 12:05 To: Multiple recipients of list ORACLE-L Subject: Question about LMT   Hi all, I created a tablespace in LMT.  I created all my datafiles with an extra 64 Kb for the bitmap index. My question is : If I want to resize my datafile, do I have to keep this extra 64 Kb ? Example :       datafile size   = 500M + 64 Kb = 512064 Kb                 resize to 50M   = 51200 or 51264 Kb TIA ----------------- Luc Demanche CETELEM T�l.: 01-46-39-14-49 Fax : 01-46-39-59-88