on 12-12-2008 10:52 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.