Last updated on September 3rd, 2016 at 01:34 amWe 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 reorganization of tables using DBMS_REDEFINITION. This feature is available from 9i. How Oracle internally achieve this online reorganization To achieve this online reorganization, incrementally maintainable local materialized views … Continue reading Online reorganisation of tables using DBMS_REDEFINITION »