Home » Developer & Programmer » Forms » Max. columns in Unique Constraint
Max. columns in Unique Constraint [message #117573] Thu, 28 April 2005 05:49 Go to next message
muktha
Messages: 4
Registered: April 2005
Location: Bangalore
Junior Member
Hello,

I read in one of the site saying that maximum No. of columns allowed for Unique is 32, but in Oracle 9i is accepting 33 columns & giving error for 34 columns. So whatz the Max. No of columns allowed for Unique key Constraint.

Report message to a moderator

Re: Max. columns in Unique Constraint [message #118057 is a reply to message #117573] Mon, 02 May 2005 20:19 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Does the number of characters have any impact on the number of columns?

David

Report message to a moderator

Re: Max. columns in Unique Constraint [message #118087 is a reply to message #118057] Tue, 03 May 2005 00:12 Go to previous messageGo to next message
muktha
Messages: 4
Registered: April 2005
Location: Bangalore
Junior Member
No, number of columns will not have any impact on number of columns

Report message to a moderator

Re: Max. columns in Unique Constraint [message #118088 is a reply to message #117573] Tue, 03 May 2005 00:51 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
From 10g doco.
Quote:

column

Specify the name of a column in the table. A bitmap index can have a maximum of 30 columns. Other indexes can have as many as 32 columns.

David

Report message to a moderator

Previous Topic: Forms 6i on web
Next Topic: Want To Change Display Item Color (Form6i)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 13:54:38 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.