Features of Online Table Redefinition
Online table redefinition enables you to:
*
Modify the storage parameters of a table or cluster
*
Move a table or cluster to a different tablespace in the same schema
Note:
If it is not important to keep a table available for DML when moving it to another tablespace, you can use the simpler ALTER TABLE MOVE command. See "Moving a Table to a New Segment or Tablespace".
*
Add, modify, or drop one or more columns in a table or cluster
*
Add or drop partitioning support (non-clustered tables only)
*
Change partition structure
*
Change physical properties of a single table partition, including moving it to a different tablespace in the same schema
*
Change physical properties of a materialized view log or an Oracle Streams Advanced Queueing queue table
*
Add support for parallel queries
*
Re-create a table or cluster to reduce fragmentation
Note:
In many cases, online segment shrink is an easier way to reduce fragmentation. See "Reclaiming Wasted Space".
*
Change the organization of a normal table (heap organized) to an index-organized table, or do the reverse.
*
Convert a relational table into a table with object columns, or do the reverse.
*
Convert an object table into a relational table or a table with object columns, or do the reverse.
Partager