Skip to Content
Dec 12, 2008 at 10:52 AM

Reorg moving indexes... how to avoid that?


Hi Everyone,

I'm running a db reorg for some tablespaces in oracle by following Note 646681 under section IV.

The problem is that i want to reorg PSAPVOLD into PSAPVOL2D (in order to be able to drop PSAPVOLD and then rename PSAPVOL2D) the problem is that the indexes of the 2 tables inside PSAPVOLD are been moved into PSAPVOL2D (from PSAPVOLI) and i want to avoid it.

I can't find any documentation on how to prevent reorg from touching the indexes, basically i want to do the indexes later in order to keep thing tidy.

I'm using command

brspace -f tbreorg -s <reorg_tsp> -t "*" -n <new_tsp> -p <par_degree>

Any Ideas?