Re: extents question on LMT

2003-01-28 Thread Jared . Still
d "Guang Mei" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/28/2003 12:06 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:extents question on LMT Hi: Oracle 8173 on Sun 2.8

extents question on LMT

2003-01-28 Thread Guang Mei
Hi: Oracle 8173 on Sun 2.8. When we had tablespace created as DMT, I used to occuasionally find all indexes in a schema which have multiple extents and run a script to compress each of them into one single extent (maybe this is not necessary, but that's another topic). But I find lately that w