No other suggestions on this topic? Thanks. -----Original Message----- From: Allen, Brandon [mailto:Brandon.Allen@xxxxxxxxxxx] Sent: Thursday, July 28, 2005 2:31 PM To: Roger Xu; Oracle-L@Freelists. Org (E-mail) Subject: RE: suggestions for table/index reorg This is a good one: <http://www.actoug.org.au/Downloads/oracle_index_internals.pdf> http://www.actoug.org.au/Downloads/oracle_index_internals.pdf Also, try searching asktom.oracle.com - you'll get a lot of good info there. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Roger Xu Sent: Thursday, July 28, 2005 12:15 PM To: Oracle-L@Freelists. Org (E-mail) Subject: suggestions for table/index reorg Oracle 9.2.0.4.0 with DMTS (dictionary-managed tablespace) Solaris 9 Any documents, web links, white papers which can help me to convince my management that table/index reorg should be avoid for it is unnecessary, even we are not using LMTS. The reason we cannot use LMTS is: SAP 4.0B does NOT support locally-managed tablespace. Thanks, Roger This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material. ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support@xxxxxxxxxxxx