Managing Partition DDL

On Oracle databases, you can implement Oracle Partitioning.

Partitioning enables you to subdivide tables and indexes into smaller pieces, such that the database system can access and manage the partitioned objects at a finer level of granularity. This provides for more efficiency for administration with faster backups, for example, and for better transaction performance with queries being able to isolate the relevant data more quickly through partitions.

To mange partition DDL, in Application Designer select Tools, and then Data Administration, and then Partitioning.

This example illustrates the use of the Maintain Partitioning DDL dialog box for managing partitioning DDL.

Important:

PeopleTools performs no validation on SQL entered in the Table or Index partitioning DDL edit boxes. You must validate the syntax on your own.

Details for implementing this feature are covered in the product documentation for PeopleTools: Data Management.