Hi, I do rebuild index for table AP_INVOICES_ALL
but it seems that no effect on extents.

select owner, segment_name, tablespace_name, count(*), sum(bytes)
  2  from sys.dba_extents
  3  where segment_name like 'AP_INVOICES_N3' and tablespace_name='APX'
  4  group by owner, segment_name, tablespace_name
result :
AP         AP_INVOICES_N3       APX                     45   46202880

and then :
alter index AP.AP_INVOICES_N3
  2* rebuild compute statistics online nologging tablespace APX

but the extents still as above.
any advice?

regards

On Tue, 14 Oct 2003, John Kanagaraj wrote:

> Hemant,
> 
> This applies on 11i only. I would rebuild all indexes supporting the
> WF_ITEM_ACTIVITY_STATUSES and WF_ATTRIBUTE_VALUES tables. I have been

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: hernawan
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to