Duplicated Item Poids Within Multischema (Doc ID 1953725.1)

Last updated on MARCH 06, 2019

Applies to:

Symptoms

Identified several duplicate item_t poid_id0 (around 1000) within multischema.

E.g.
POID_DB    POID_ID0           POID_TYPE        POID_REV    CREATED_T
1 286524033177397918 /item/cycle_forward 3 1407189688
2 286524033177397918 /item/U_O2       0 1407238001

Identified that duplicated poids are generated only in ITEM_T table and duplicates are always caused by combination of system and usage items.

E.g.
in DB1 poid 286524033177397918 is /item/cycle_forward
in DB2 poid 286524033177397918 is /item/U_O2

Have set POID_IDS2 sequence.
In DB1 ODD increment by 2:
POID_IDS2 MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 2 START WITH 100101180579 CACHE 20;
In DB2 EVEN increment by 2:
POID_IDS2 MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 2 START WITH 100038027536 CACHE 20;

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.