Unique Key Constraints

[Guest_imported]

Hi,
I wanted to know if there is any upper limit for the number of Unique Key Constraints that can be defined for a table in ORACLE. If so, then what is the maximum number of constraints that can be defined.

Thanks and Regards,
Vidya

 

[jjonesal]

According to OTN, there is no limit for constraints on a column or a limit on the number of indexes. I guess the only limit imposed would be that of a max of 1000 columns in the table.

Of course, I haven't tried it. I'm going strictly by Oracle's documentation.

J. Jones
jjones@cybrtyme.com