| After deleting a constraint, i am getting the constraint violation problem. [message #151121] |
Tue, 13 December 2005 05:56  |
balivada_sudha_rani
Messages: 13
Registered: April 2005
Location: Bangalore
|
Junior Member |
|
|
Hi,
Sometimes i come across a different issue. That is after deleting a constraint i come across the same constraint violation problem.This is not happening for all.But this comes into notice number of times.
Can any of u advise why this happens ????I cross check that after deleting the constraints the corresponding index also droped.
Pls advise.
Thanx
Sudha
|
|
|
|
| Re: After deleting a constraint, i am getting the constraint violation problem. [message #151128 is a reply to message #151121] |
Tue, 13 December 2005 06:44  |
kiran
Messages: 503
Registered: July 2000
|
Senior Member |
|
|
Did you mean that you are getting constraint violation error from forms.Please confirm.
In SQL , it never happened so. Just tried ,
SQL> create table t1
2 (no number(4) primary key);
Table created.
SQL> insert into t1 values(10);
1 row created.
SQL> insert into t1 values(10);
insert into t1 values(10)
*
ERROR at line 1:
ORA-00001: unique constraint (USER1.SYS_C004674) violated
SQL> alter table t1 drop primary key;
Table altered.
SQL> insert into t1 values(10);
1 row created.
SQL> select * from t1;
NO
----------
10
10
If the problem is from forms , try compiling all and try again.
--Kiran.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
