you could have no object that need reorg ... use dbms_space.asa_recommendations ... and control the report. Are you sure you need scheduled reorg ? is it not better to make reorg when you really need it ? Bye 2012/9/7 Raja Subramaniyan <raja.s28@xxxxxxxxx> > Hi, > I am trying to find the good candidate / objects for reorg in SAP > databases. We are planning to do, > > We are planning to do weekly reorg, monthly once and every six month once. > Accordingly we need to identify the objects and schedule the re-org. Any > one in the group, provide assistance on that. > > Note : Databases are SAP Instances. ( ECC, SCM and CRM products ) > > Regards, > Raja > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l