PrimaryKey setting for Existing Table[Oracle8]
I faced One problem in Oracle8.0.That is
Consider a table
sample(num number,name varchar2);
It have the values like this;
From this i want to set primary key on this num column.
According to the primarykey rule it should not possible.
But in Oracle8.0 it accept it and make the num column as a Primary key. what is the problem???.
Are you using 8.0.3 or 8.0.4 if so you are hitting bug 604833
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Click Here to Expand Forum to Full Width