Chat now with support
Chat with Support

Space Manager with LiveReorg 9.0 - User Guide

Smart Start for Space Manager Collect Statistics Profile DML Activity Manage Storage Reorganize Objects with Reorg Manager Partition Tables with the Partitioning Wizard Run and Monitor Scripts Run Reports Options Troubleshooting Administration Functions Appendix About Us

About Standard Reorg with Reorg Manager

About Standard Reorganizations

Standard reorganization is an offline reorganization method. This means that the objects being reorganized are not available and should not be accessed during a standard reorganization. DML or DDL activity should not be performed against these objects by users or applications. If either type of activity is performed, data loss can occur.

Note Standard reorganizations for objects from anywhere in a database can be performed with Reorg Manager.

Advantages of Standard Reorganization

One of the main advantages of standard reorganization with Reorg Manager is that it supports more object types, datatypes, and options than any other method.


What Is Not Supported for Standard Reorganizations

This topic lists which Oracle features are not supported for standard reorganizations. Use the information in this topic when selecting which reorganization method to use and which objects to include in a reorganization.

Category Oracle Feature Not Supported
Tables and Indexes

Temporary tables


Tables with dimensions


Advanced Queuing tables


Replication tables; objects that are part of a replication group


External tables


Domain indexes (including interMedia and ConText indexes)

IOTs and Clusters

Bitmap indexes on IOTs


Clusters that contain tables with LONG columns

User Defined Data Types

Object tables (data types for tables)


Nested tables

Various Data Types

XMLType tables


Oracle Label Security



About Live Reorg with Reorg Manager

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating