Examples Oracle Online Table Redefinition
Examples Oracle Online Table Redefinition Online Table Redefinition Examples For the following examples, see Oracle Database PL/SQL Packages and Types Reference for descriptions of all DBMS_REDEFINITION subprograms. Example Description Example 1 Redefines a table by adding new columns and adding partitioning. Example 2 Demonstrates redefinition with object datatypes. Example 3 Demonstrates redefinition with manually registered dependent objects. Example 4 Redefines a single table partition, moving it to a different tablespace. Example 1 This example illustrates online redefinition of the previously created table hr.admin_emp, which at this point only contains columns: empno, ename, job, deptno. The table is redefined as follows: •New columns mgr, hiredate, sal, and bonus are added. (These existed in the original table but were dropped in previous examples.) •The new column bonus is initialized to 0 •The column deptno has its value increased by 10. •The redefined table is partitioned