My Oracle Support Banner

How to Re-Organize a Table Online (Doc ID 177407.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 8.0.3.0 to 11.2.0.3 [Release 8.0.3 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

Prior to Oracle9i, any table re-organizations and redefinitions forced the table to be offlined for the duration of the operation.

From Oracle9i forward, table re-organizations and redefinitions can be performed online. This note explains how to reorganize a table online.

NOTE: This note does not cover the use of row ids. As of 9.2.0.5, additional parameters were added to the DBMS_REDEFINITION
packages which allow redefinition to use a row id instead of a primary key.

 

Scope

This article is intended to help the database administrators to do Online table redefinition in Oracle9i and later.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.