The smart partitioning process creates segments by dividing each table consistently across the segmentation group. This process organizes transactions in the segmentation group by the dimensions you associated with the group. This method of partitioning maintains the referential integrity of each transaction.

With smart partitioning, a table can belong to one segmentation group at a time. Segmentation groups might not include every table in an application module because not every table is an ideal candidate for segmentation. Tables with a large and growing number of transactions are the best candidates for segmentation.

If you purchased an application accelerator such as the Oracle E-Business Suite or PeopleSoft accelerator, some segmentation groups are predefined for you. If you need to create a segmentation group manually, you must first import metadata from the application database and create an application module. Then you can select the tables you want to include in the segmentation group.

After you select the segmentation group tables you must mark the driving tables, enter constraints, associate dimensions with the segmentation group, and define business rules.