select DISTINCT b.table_name from ALL_CONS_COLUMNS a,ALL_CONSTRAINTS b
where a.constraint_name = b.constraint_name and constraint_type = 'P' and a.owner='ITIL_SJ'
constraint_type = 'P' 键的类型
owner 数据库用户名
constraint_name 约束名
可以参照帖子:http://topic.csdn.net/t/20010827/10/257938.html