Forcing the creation of new partitions for BSI tables

Document ID : KB000010106
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

With data partitions configured, most commonly on T_RAW_DATA, you may wish to manually force the generation of fresh partitions. This could be because there was a problem previously with their generation, and you're receiving the Oracle error

ORA-14400: inserted partition key does not map to any partition

when trying to store adapter data. It may just be because you need to reference future dates in your exceptions. Or, if there has been a period where the TaskHost and ScriptHost services were disabled overnight, then the appropriate job may not have been running automatically.

 

Instructions:

The partition tools are stored in the Database package 'PART_MNG_PKG'. This package should have been compiled during creation in Oracle; if it is invalid, then recompile it.

It contains a number of tools for working with database partitions, and picks up its information on partition configuration within BSI from the table T_PART_MNG_PARAMS - the rows within it will describe how your partitions and purge settings are defined out of the box.

To perform the cleanup procedure, you can run the following SQL:

BEGIN
PART_MNG_PKG.RUN_PROCESS();
END;

Additional Information:

The Part_Mng_Pkg.sql can be found under the DVD, if you need to recreate it from scratch:

DVD:\SetupDB\InstallDB\Build_Schema\Packages