Reorganization of tablespaces, tables and indexes.

Former Member · ‎10-18-2007

Hello Experts,

What is the concept of tablespaces, statistics , tables and indexes in SAP/Oracle ? Where are they used and what are they meant for ?

Wt is the concept and procedure of performing Reorganization of tablespaces, tables and indexes ? why do we need it for ?

Requested to revertb at earliest as its urgent . points guaranteed .

Regards,

Somya

madhukara_shenoy · ‎10-18-2007

Hello Somya,

Probably difficult to explain entire information in this thread. But you definately get good information in the following link

Please drill down through menus, and you will be able to get good information.

Also you can check the following SAP notes

666061 FAQ: Database objects, segments and extents

912620 FAQ: Oracle indexes

588668 FAQ: Database statistics

592393 FAQ: Oracle

541538 FAQ: Reorganizations

Regards,

Madhukar

Former Member · ‎10-18-2007

Hi Somya,

Seems you need an Oracle basis tutorial. You can find a lot of them with a fast internet search. A good sample: http://dev.fyicenter.com/faq/oracle/index.html

Best Regards,

JC Llanes.

Re: Mass Update a Zfield in Std Table with Split &...