RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

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: hernawan_at_makro.co.id

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: ListGuru_at_fatcity.com (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).