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
*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
*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