Oracle table partitioning

You can use Oracle partitioning to aid the maintainability of large tables. You should not view partitioning as a performance tool to achieve higher throughput; under certain circumstances it may increase throughput, but these circumstances are rare in Sterling Selling and Fulfillment Foundation. However, as a tool to improve the maintainability of the largest tables, partitioning can be valuable. Before implementing any partitions in a production environment, it is essential that you test the changes with the expected production workflows. Sterling has tested and developed the following points with regard to Oracle partitioning and the Sterling Selling and Fulfillment Foundation application:

Table partitions should ideally be set up on the initial installation. Tables may be partitioned once loaded. We have used and recommend testing Oracle's "dbms.redefinition" package. This package is well documented by Oracle in the Oracle® Database PL/SQL Packages and Types Reference and the Oracle® Database Administrator's Guide.

Oracle does not support LONG columns in table partitions. Any LONG columns need to be converted to CLOB before attempting to partition a table. The LONG to CLOB conversion can be performed by the "dbms.redefinition" package at the same time as the table partitioning.