Reorg moving indexes... how to avoid that?

[JPReyes]

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?

Regards

Juan

[lbreddemann · Accepted solution]

Hi Juan,

the easiest way would obviously be to use the user interface brspace instead of trying to figure out the command line options.

Then you can enter a different target tablespace for indexes.

You may of course as well read the documentation/notes on brspace (or just type in 'brspace -help') and figure out that there is a option like this:

 [-i|-indts <tablespace>]
         separate index tablespace
         default: table tablespace

By the way - there's really no big point in seperating index and data tablespaces. So the 'tidyness' is just a matter of your own gusto.

regards,

Lars

[JPReyes · Accepted solution]

Thanks for the tip...using switch -i did the trick!

Cheers

Juan