kokoroinaka Posted November 19, 2008 Share Posted November 19, 2008 hello, I am developping a C#. application which uses Oracle 9i,I get ORA-00001(unique constraint) Error on executing the sql below;I know sql below is little strange( which use unique key in 'SET' statement) .but It worked on My Oracle Server. but it didn't on Client's.does anybody know why this error occurs or why this error did not occur on my PC,thanks,[update sql](key is CD and SDATE)Update TBL1 set CD = 'A', NAME = '1', SDATE=TO_DATE('2008-10-31 00:00', 'YYYY-MM-DD HH24:MI' )WHERE CD = 'A' and SDATE=TO_DATE('2008-10-31 00:00', 'YYYY-MM-DD HH24:MI' )[table definition]CREATE TABLE TBL1(CD VARCHAR2(8),NAME VARCHAR2(30),SDATE DATE,DATATEXT VARCHAR2(100))[unique constraint]CREATE UNIQUE INDEX TBL1_KEY1ON TBL1(CD, SDATE)PCTFREE 10INITRANS 2MAXTRANS 255TABLESPACE INDEX_SPACESTORAGE(INITIAL 500K NEXT 500K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)LOGGING Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now