Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the Oracle9i online data reorganization capabilities?

April 26, 2017Data online oracle9i Reorganization

0

Posted

What are the Oracle9i online data reorganization capabilities?

1 Answer

0

Posted

Oracle8i introduced many useful online data reorganization features such as creating, rebuilding, and coalescing indexes online; moving and reorganizing index-organized tables (IOTs) online. Oracle9i further extends Oracle’s online capabilities: support for IOT secondary indexes, support for additional index types, and support for analyze validate structure online. The latest Oracle9i release adds rename column and constraint online capabilities. But the most exciting online feature in Oracle9i is the online data redefinition feature. The feature allows Oracle database administrators to redefine tables online. For example, administrators can transform a heap table to an IOT or change a non-partition table to a partition table online. Moreover, during the redefinition administrators can change the table’s physical or storage attributes, move the table to a new tablespace, modify the table structure, or transform data in the table.