Zurück
-
Titel
Is Oracle Partitioning used by Space Management with Live Reorg? -
Beschreibung
Is Oracle Partitioning used by Space Management with Live Reorg?Why is the Online Switch style not available?Why is only the T-lock switch style available? -
Lösung
There are two types of switch methods in Live Reorganization :
1. Online switch
2. T-lock switch
The Online switch reorg method requires Oracle partitioning to be enabled and licensed on the database as the copy table created on a standard table will be partitioned. In order to accomplish the switch (replace the original table with the reorganized one) with the Online switch reorg method, the product will use the Oracle EXCHANGE PARTITION command.
Note: If Oracle partitioning is not installed on the database, the Online switch reorg method is not enabled on the product screen and therefore cannot be selected.
The T-Lock switch reorg method does not require Oracle partitioning as it creates a standard table for the copy table. In order to accomplish the switch with the T-Lock reorg method, the product will use the Oracle table RENAME command.
The Online Redefinition reorg method requires Oracle's DBMS_REDEFINITION package to be installed on the database. In order to accomplish the switch with the Online Redefinition reorg method, the product will use Oracle's DBMS_REDEFINITION commands.
Customers that have partitioning installed and do not have an Oracle license for it may use the following live reorg options in the product :
1. T-LOCK switch reorg method
2. Online Redefinition reorg method
-
Weitere Informationen
This applies to all version of Space Management with Live Reorg.