ORA-02437 错误
要给一张表建主键,出现下列错误
ORA-02437 :无法启用(nbtravel.t_base_cicerone_test)-违反主关键字
主键列里面的数据有问题:有null或者有重复
null:好判断
重复:查询重复列的语句
select * from (select count(*) as a ,t.cicerone_id from nbtravel.t_base_cicerone_test t group by t.cicerone_id) b where b.a>1