Home » SQL & PL/SQL » SQL & PL/SQL » Unique Constraint size limit
Unique Constraint size limit [message #318448] Tue, 06 May 2008 20:36 Go to next message
florida
Messages: 82
Registered: April 2006
Member
I have 12 fields in my Oracle 9 i table where I created a unique constraint using 10 fields. For about 3 of the 10 that are varchar2(1000) I cant go larger because the unique constraint gives error message about size. Is this normal or is it because I have alot of fields in my unique contraint?
Re: Unique Constraint size limit [message #318449 is a reply to message #318448] Tue, 06 May 2008 21:00 Go to previous message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>Is this normal or is it because I have alot of fields in my unique contraint?

Yes

Have the tables been normalized to Third Normal Form?
Previous Topic: How to pass decimal value to Oracle Stored Procedure
Next Topic: IP of Oracle server
Goto Forum:
  


Current Time: Tue Dec 06 12:23:42 CST 2016

Total time taken to generate the page: 0.11417 seconds