SQL> select distinct c.table_name 2 from user_constraints c 3 where c.table_name not in( 4 select b.table_name 5 from user_cons_columns a, user_constraints b 6 where a.constraint_name = b.constraint_name 7 and b.constraint_type = 'P' ) 8 ; TABLE_NAME ------------------------------ BS_AGE_GRZH_JZLX BS_BIZTOTAL_HIS_20111231 BS_COMM_DO_TYPE BS_CORP_FINANCEPAY BS_CORP_HOSPITAL_HIS BS_CORP_RECEIVEMODE BS_HOSP_BIZ_LOG_OPERATE BS_INDI_JOIN_TYPE BS_INDI_PHOTO 9 rows selected