Online table redefinition using DBMS_REDEFINITION
We often need to perform reorganization of the tables. We have to do offline by taking the system down and it consumes a 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 redefinition There are some Restrictions Tables with …
Online table redefinition using DBMS_REDEFINITION Read More »