Oracle system table

From: Mounilk <mounilkadakia_at_hotmail.com>
Date: Tue, 27 Jul 2010 22:16:44 -0700 (PDT)
Message-ID: <17e1f621-7232-440d-99d3-68f432262eb9_at_m17g2000prl.googlegroups.com>

Hi,
I am working on oracle database which has a few tables that do not have any primary keys. Unfortunately, I cannot modify the table designs.

I need to find out the fields in the table that make the record unique.

I am not very familiar with Oracle and its system tables, but am pretty sure I should be able to get this information from some system table.

Any help is greatly appreciated.

Regards,
MounilK Received on Wed Jul 28 2010 - 00:16:44 CDT