Finding an oracle constraint by name

SELECT owner, table_name
  FROM user_constraints
 WHERE constraint_name = <<your constraint name>>

or if you have sysadm privileges: 

SELECT owner, table_name
  FROM dba_constraints
 WHERE constraint_name = <<your constraint name>>