Well technically if you wanted to convert to LMTs on 4.0B you could. Take a look at notes: 662900 and 659487. The title of note 662900 is "Using LMTS in R/3 releases 3.1I-4.6D" Thanks! ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon Sent: Thursday, July 28, 2005 12:31 PM To: roger_xu@xxxxxxxxxxx; 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 184.108.40.206.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 Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.