Also, the move online option
is only available for nonpartitioned index-organized tables.
Redefining Tables Online
You can change a table??™s definition while it is accessible by the application users. For example,
you can partition a previously nonpartitioned table while it is being used??”a significant capability
for high-availability OLTP applications.
As of Oracle Database 11g, there are very few restrictions on what types of tables cannot be
redefined online. Here are the key restrictions:
After redefining a table with materialized view logs, the dependent materialized views
must be refreshed with a complete refresh.
The overflow table of an IOT must be redefined at the same time as the base IOT.
Tables with fine-grained access control cannot be redefined online.
Tables with BFILE columns cannot be redefined online.
Table with LONG and LONG RAW columns can be redefined, but the LONG and LONG
RAW columns must be converted to CLOBs and BLOBs.
Tables in the SYS and SYSTEM schemas cannot be redefined online.
Temporary tables cannot be redefined online.
The following example shows the steps involved in redefining a table online. First, verify that
the table can be redefined. For this example, the CUSTOMER table will be created in the SCOTT
schema and then redefined:
create table CUSTOMER
(Name VARCHAR2(25) primary key,
Street VARCHAR2(50),
City VARCHAR2(25),
State CHAR(2),
Zip NUMBER);
Next, verify that the table can be redefined by executing the CAN_REDEF_TABLE procedure
of the DBMS_REDEFINITION package.
Pages:
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767