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.
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.
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 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center
