|
Home > Archive > Oracle certifications > March 2002 > Moving Indexes
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| MartyGranzo 2002-03-12, 8:55 am |
| I don't understand the command in the Exam Cram book and it's explained poorly:
ALTER INDEX pk_emp
REBUILD TABLESPACE users;
This is supposed to be moving an index to another tablespace but I can't figure out the source tablespace and the destination tablespace. | |
|
| Its basicaly the command to rebuild an index. Indexes need to be rebuilt sometimes if they are built upon columns that have seen alot of deletes/updates etc. You can specify which tablespace to store the index in and so, yes, that command is efectively moving an index to another tablespace but it is not simply moving the existing index, but rebuilding it so that it is up to date with the columns it references.
Does that help? | |
| MartyGranzo 2002-03-12, 4:43 pm |
| Does that command rebuild the index and put the index in the "users" tablespace, regardless of the tablespace it currently resides in? | |
|
| Yeah it will rebuild the index in whatever tablespace you identify in the statement. |
|
|
|
|