I know that under 8i an above, it is very easy to move a table or index from one tablespace to another. However, can this be done in 7.3.4? I cannot use the 8i command.
So, how to do this? Do I have to drop and recreate the object or can I do an alter table command and change the tablespace name in the storage clause?
You can't change tablespace parameters with an ALTER TABLE in 7.3.4
I think your only options here are:
1. CREATE TABLE xxx AS SELECT * FROM xxx
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
ALTER INDEX REBUILD is available in 7.3.4, I think.
Click Here to Expand Forum to Full Width