Re-org of tables
Hi,
We have a couple of questions for our 10.2.0.4 production database
We have a process that purge magnitude of data from underlying tables
1) Is there a way we can determine if a particular table is a candidate for re-org?
2) Once we determine the candidates for re-org, we can do an export / import to re-org using data pump
Once we export the table and Import it back, the indices would be rebuilt as part of the Import process. Correct?
3) Is there a way we can do this re-org online? Is the online re-org really stable in 10.2.0.4. Are there
any known issues with doing online re-org?
We have a couple of questions for our 10.2.0.4 production database
We have a process that purge magnitude of data from underlying tables
1) Is there a way we can determine if a particular table is a candidate for re-org?
2) Once we determine the candidates for re-org, we can do an export / import to re-org using data pump
Once we export the table and Import it back, the indices would be rebuilt as part of the Import process. Correct?
3) Is there a way we can do this re-org online? Is the online re-org really stable in 10.2.0.4. Are there
any known issues with doing online re-org?
0