We often need to perform reorganization of the tables . We have to do offline by taking system down and it consumes lot of time.we can perform an Online table redefinition using DBMS_REDEFINITION. This feature is available from 9i. How Oracle internally achieve this Online table redefinitionTo achieve this online reorganization, incrementally maintainable local materialized […]