RE: Question about LMT

[Christopher Spence]

Title: Question about LMT

i agree, I think the 64k is a mute point, at worse case you have one unusable extent at the end when using LMT.  But if your extents are 100M, it may be a little issue.   "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 10:11 AM To: Multiple recipients of list ORACLE-L Subject: RE: Question about LMT Luc,   How are you calculating the size you want to resize the datafiles to? If it is based on how much they are actually used, then no. If it is based on an external calculation of how much space you expect to use, then yes, but 64k won't make much difference when you're dealing with files of hundreds of megabytes.   HTH,   g.   -----Original Message----- From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]] Sent: 13 June 2001 13:56 To: Multiple recipients of list ORACLE-L Subject: RE: Question about LMT   Hi Guy,   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.   Luc