Data Archive
- Data Archive 6.4.4
- All Products
Step
| Description
|
---|---|
Create audit snapshot - before
| Creates a snapshot of the state of the objects, such as indexes and triggers, that belong to the segmentation group before the ILM Engine moves any data.
|
Create optimization indexes
| Creates optimization indexes to improve smart partitioning performance. Indexes are used during the segment data step to generate the selection statements that create segments. This step is applicable only if you have defined optimization indexes in the Enterprise Data Manager.
|
Preprocess business rules
| Uses interim tables to preprocess the business rules you applied to the segmentation group. This step is visible only if you selected to use interim table processing in the Enterprise Data Manager.
|
Get table row count per segment
| Estimates the size of the segments that will be created when you run a segmentation policy.
Default is skip.
|
Allocate datafiles to mount points
| Estimates the size of tables in the segmentation group based on row count and determines how many datafiles to allocate to a particular tablespace.
Default is skip.
|
Generate explain plan
| Creates a plan for how the smart partitioning process will run the SQL statements that create segments. This plan can help determine how efficiently the statements will run.
Default is skip.
|
Create tablespaces
| Creates the tablespaces for the new segments.
|
Segment data
| Required. Moves the data into the new tablespaces.
|
Drop optimization indexes
| Drops any optimization indexes you created in the Enterprise Data Manager.
|
Create audit snapshot - after
| Creates a snapshot of the state of the objects, such as indexes and triggers, that belong to the segmentation group after the ILM Engine moves the data into the segments.
|
Compare audit snapshots - summary
| Compares and summarizes the before and after audit snapshots.
|
Compile invalid objects
| Compiles any not valid objects, such as stored procedures and views, that remain after the ILM Engine creates segments.
|
Enable access policy
| Enables the access policies you applied to the segmentation group.
|
Collect segmentation group statistics
| Collects database statistics, such as row count and size, for the segmentation group.
|
Clean up after segmentation
| Cleans up temporary objects, such as tables and indexes, that are no longer valid after segment creation.
|