Converse agora com nosso suporte
Chat com o suporte

Space Manager with LiveReorg 9.1 - 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

Miscellaneous

Oracle Label Security

 

  

About Live Reorg with Reorg Manager

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação