Creating your own Oracle Metadata Repository (MDS) partitions

Just required some Oracle Metadata Repository (MDS) partitions for some testing. If you ever get to the same situation just use MDS_INTERNAL_COMMON.getOrCreatePartitionID procedure which is shipped with the MDS Schema when installing it using the Repository Creation Utility (rcu):

DECLARE
 lv_partitionID MDS_PATHS.PATH_PARTITION_ID%TYPE;
 lv_partitionExists integer;
BEGIN
 mds_internal_common.getorcreatepartitionid(
 lv_partitionID,
 lv_partitionExists,
 'foo'
 );

mds_internal_common.getorcreatepartitionid(
 lv_partitionID,
 lv_partitionExists,
 'bar'
 );
END;
/

After the anonymous block is completed you can check out your brand new partitions:

Created partitions
Created partitions

Leave a Reply