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:
