Oracle9i contains new online reorganization and redefinition capabilities. Any physical attribute of the table can be changed online. The table can be moved to a new location. The table can be partitioned. The table can be converted from one organization (e.g. heap) to another (e.g. index organized). Additionally, many logical attributes can be changed. Column names, types, and sizes can be changed. Columns can be added, deleted, or merged. The major restriction is that the primary key of the table cannot be modified.
Oracle 9i provides a new DBMS_REDEFINITION PL/SQL package to redefine tables online. When a table is redefined online, it is accessible to DML during much of the redefinition process.
No comments:
Post a Comment