1.How to move an table or index from one tablespace to another tablespace.
2.Can we give a movement action in one tablespace?
Yes,I has been tested it in ora8174 and ora9205, results are successful.detail as below:
someone will ask me "Mr. Compard,how about result of following?":
I will not show the answer directly, but tell him SQL "alter" is belong to DLL, what do you think about it?
3.Best use of Move action.
I think the best use is falling back the High-water-mark instead of "backup data/truncate/insert" way.Of course falling back the High-water-mark can improve the performance.
A: Cause : sql sentenses are wrong. I lost the key words "tablespace" and the error is occured.
A:Today ,after moved 3 big tables(size >1G),I get the error ORA-01502 when query them.No way but rebuild the indexes to resolve this error.It spend me more time to do it. So I think maybe exp/imp is better.
Q:How to move LOB index
A:It's can't be move directly,but you can use move it by SQL for moving table,add" LOB(
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10325341/viewspace-573088/，如需转载，请注明出处，否则将追究法律责任。