FreeLists / oracle-l / RE: suggestions for table/index reorg

["Roger Xu" <roger_xu@xxxxxxxxxxx>]

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