电脑select error;列名`lj_righ错误怎么办?
发布网友
共1个回答
热心网友
ORA-01452: cannot CREATE UNIQUE INDEX; plicate keys found
这句话的意思是有重复数据，解决办法是删除重复的列，如下：
delete RA_RIGHTCONFIG where rowid not in(select min (rowid) from RA_RIGHTCONFIG group by TYPE, NAME);
安全起见你还是先查询下吧
select * from RA_RIGHTCONFIG where rowid not in(select min (rowid) from RA_RIGHTCONFIG group by TYPE, NAME);
