|
How are the indexes updated? Whenever a table partition is modified using a DDL command, the associated index partitions are placed in the default tablespace or in the same tablespace as the data segments. This has been an issue with the previous releases of the Oracle databases.
With the Oracle 10g release, it has become possible to modify the partitioned table, using the UPDATE INDEXES clause. It can rebuild the associated index segments automatically. It helps to reduce the level of management needed and also enhances the availability of the data in the table.
You can create and Alter the table and update indexes to reflect the changes.
|
