- 查询表主键约束
select * from dba_constraints where table_name ='REV_TOMATERIAL_REPORTLOSS_ITEM' and constraint_type ='P'
REV_TOMATERIAL_REPORTLOSS_ITEM为你的表名
2. 如果表名太长,生成的主键约束会忽略后面的,主键约束一共30位,其中还包括了’PK_’,如果表名太长,比如:
REV_TOMATERIAL_REPORTLOSS_ITEM和REV_TOMATERIAL_REPORTLOSS_DET表,他两生成的主键约束都是PK_REV_TOMATERIAL_REPORTLOSS_1,就会相同,就会创建表失效