How to reorganize Table?
922134Sep 7 2012 — edited Sep 7 2012Hi,
My oracle database version is 10.2.0.5 on windows 2003 server.
I want to reorganize one of my table.
Table size is 460GB.
I am prefering expdp impdp option to use.
Please, can anyone provide me the steps to reorganize table.
whether my below steps are correct :
1) export of full schema
2) drop schema
3) import schema
Thanks.