Online table redefinition includes which three features?
A.
Tables without primary keys are supported
B.
Parallel support can be added or removed
C.
Storage parameters for the table can be modified.
D.
The redefinition can be done across different schemas.
E.
User-defined data types BFILES or LONG columns are supported
F.
Organization can be changed from heap-organized to IOT structure or vice versa
Explanation:
Online table redefinition enables you to:
? Modify the storage parameters of a table or cluster (C)
? 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 (B)
? 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 .(F)
? 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.
REF.: Oracle(r) Database New Features Guide, 15-22