Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Zajcica
Starting Member
22 Posts |
 Posted - 2013-06-17 : 12:56:24
|
| Please!I am adding new row!wrote:insert into program (c1c2...) values (v1,v2...); and am getting ora-00001.Please, I tried to oracle forum but they are all closed...need instant help!What might be wrong?p.s. habe one primary key and one foreign...but this should NOT interfear, because i can use any fk_ id I want, don+t I? (in this example!)Many thanks! |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-17 : 13:01:50
|
quote:
Originally posted by Zajcica
Please!I am adding new row!wrote:insert into program (c1c2...) values (v1,v2...); and am getting ora-00001.Please, I tried to oracle forum but they are all closed...need instant help!What might be wrong?p.s. habe one primary key and one foreign...but this should NOT interfear, because i can use any fk_ id I want, don+t I? (in this example!)Many thanks!
I am not an oracle expert - but ORA-0001 appears to be a uniqueness constraint violation. Check which columns have uniqueness constraints. Then examine the data in those columns and compare with the data you are going to insert to see if there are any duplicates. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
|
Zajcica
Starting Member
22 Posts |
Posted - 2013-06-18 : 02:46:29
|
quote:
Originally posted by James K
quote:
Originally posted by Zajcica
Please!I am adding new row!wrote:insert into program (c1c2...) values (v1,v2...); and am getting ora-00001.Please, I tried to oracle forum but they are all closed...need instant help!What might be wrong?p.s. habe one primary key and one foreign...but this should NOT interfear, because i can use any fk_ id I want, don+t I? (in this example!)Many thanks!
I am not an oracle expert - but ORA-0001 appears to be a uniqueness constraint violation. Check which columns have uniqueness constraints. Then examine the data in those columns and compare with the data you are going to insert to see if there are any duplicates.
Yes, I have to imput sport. I have 10 sports in the table and tried to add 11th one. WHat the hell should be double? Atributs are just about sports (name, id, names in different languages..)MANY THANKS ALL! |
|
|
|
|
|
|
|
|
ora-0001, oracle