Re: Oracle system table

From: joel garry <joel-garry_at_home.com>
Date: Wed, 28 Jul 2010 10:18:03 -0700 (PDT)
Message-ID: <d43f3790-6c73-4ad0-86f1-cf911658a700_at_x24g2000pro.googlegroups.com>



On Jul 27, 10:16 pm, Mounilk <mounilkada..._at_hotmail.com> wrote:
> 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.

Ironically, as you may notice from the other replies, this is an ambiguous question with no unique answer.

What exactly is your need? I work on a database that has many tables with no primary keys, so the app makes assumptions...

>
> 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

jg

--
_at_home.com is bogus.
http://www.cuddletech.com/blog/pivot/entry.php?id=1074
Received on Wed Jul 28 2010 - 12:18:03 CDT

Original text of this message