Just for AQ this<https://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=271855.1>script on metalin is also good. Raj On 10/26/05, Stephane Faroult <sfaroult@xxxxxxxxxxxx> wrote: > > There is something else that may benefit, namely tables that are used > for queues and that had their high-water mark bumped much too high at a > given moment. But copying their contents elsewhere, truncating and > re-inserting the rows definitely don't require reorganizing the full > database ... I agree with the general feeling: waste of time. Great > opportunity to say "told you so". > > Stephane Faroult > >