RE: Question about LMT

[Christopher Spence]

Title: Question about LMT

Also note, if you try resizing a datafile smaller than it has ever been, it will complain.   In other words, if you have a 500M datafile and used 400M, then drop 300M, you cannot resize it to 100M.   "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -----Original Message----- From: Guy Hammond [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 8:15 AM To: Multiple recipients of list ORACLE-L Subject: RE: 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