Pretty wild stuff. This was in 11.2.0.3.9, EE…<\/p>\n
\r\nSQL> select * from dcspp_order_rel where order_id = 'EXP1439962334' and sequence_num = 5;\r\n\r\nORDER_ID RELATIONSHIPS SEQUENCE_NUM\r\n---------------------------------------- ---------------------------------------- ------------\r\nEXP1439962334 r406622317 5\r\n\r\nSQL> select * from dcspp_order_rel where order_id = 'EXP1439962334' and sequence_num = 7;\r\n\r\nORDER_ID RELATIONSHIPS SEQUENCE_NUM\r\n---------------------------------------- ---------------------------------------- ------------\r\nEXP1439962334 r406622317 5\r\n\r\nSQL> analyze table dcspp_order_rel validate structure online;\r\n\r\nTable analyzed.\r\n\r\nSQL> analyze table dcspp_order_rel validate structure cascade online;\r\n\r\nTable analyzed.\r\n\r\nSQL> select * from dcspp_order_rel where order_id = 'EXP1439962334' and sequence_num = 5;\r\n\r\nORDER_ID RELATIONSHIPS SEQUENCE_NUM\r\n---------------------------------------- ---------------------------------------- ------------\r\nEXP1439962334 r406622317 5\r\n\r\nSQL> select * from dcspp_order_rel where order_id = 'EXP1439962334' and sequence_num = 7;\r\n\r\nORDER_ID RELATIONSHIPS SEQUENCE_NUM\r\n---------------------------------------- ---------------------------------------- ------------\r\nEXP1439962334 r406622317 5\r\n\r\nSQL> alter table dcspp_order_rel drop constraint dcspp_order_rel_p;\r\n\r\nTable altered.\r\n\r\nSQL> drop index dcspp_order_rel_p;\r\n\r\nIndex dropped.\r\n\r\nSQL> create unique index atg_core_prod.dcspp_order_rel_p on dcspp_order_rel (order_id, sequence_num)\r\n 2 tablespace core_index_compressed parallel 16;\r\n\r\nIndex created.\r\n\r\nSQL> alter table dcspp_order_rel add constraint dcspp_order_rel_p primary key(order_id, sequence_num) using index;\r\n\r\nTable altered.\r\n\r\nSQL> select * from dcspp_order_rel where order_id = 'EXP1439962334' and sequence_num = 7;\r\n\r\nno rows selected\r\n\r\nSQL> select * from dcspp_order_rel where order_id = 'EXP1439962334' and sequence_num = 5;\r\nEXP1439962334 r406622317 5\r\n\r\nSQL>\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Pretty wild stuff. This was in 11.2.0.3.9, EE… SQL> select * from dcspp_order_rel where order_id = ‘EXP1439962334’ and sequence_num = 5; ORDER_ID RELATIONSHIPS SEQUENCE_NUM —————————————- —————————————- ———— EXP1439962334 r406622317 5 SQL> select * from dcspp_order_rel where order_id = ‘EXP1439962334’ and…<\/p>\n