Problem was with the semicolon in the ALTER TABLE line. By removing the semicolon problem solved.
ALTER TABLE IDN_APPMGT_APP ADD CONSTRAINT APPLICATION_NAME_CONSTRAINT UNIQUE(APP_NAME, TENANT_ID) On Fri, Apr 4, 2014 at 10:12 AM, Prasad Tissera <[email protected]> wrote: > Can anyone help to figure out what is wrong with this SQL. > > CREATE TABLE IDN_APPMGT_APP ( > ID NUMBER(7, 0), > APP_NAME VARCHAR (255) NOT NULL , > USERNAME VARCHAR (255) NOT NULL , > TENANT_ID NUMBER(7, 0) NOT NULL, > USER_STORE VARCHAR (255) NOT NULL, > ROLE_CLAIM VARCHAR (512), > PRIMARY KEY (ID) > ) > / > CREATE SEQUENCE IDN_APPMGT_APP_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE > / > CREATE OR REPLACE TRIGGER IDN_APPMGT_APP_TRIGGER > BEFORE INSERT > ON IDN_APPMGT_APP > REFERENCING NEW AS NEW > FOR EACH ROW > BEGIN > SELECT IDN_APPMGT_APP_SEQUENCE.nextval INTO :NEW.IDFROM > dual; > END; > / > ALTER TABLE IDN_APPMGT_APP ADD CONSTRAINT APPLICATION_NAME_CONSTRAINT > UNIQUE(APP_NAME, TENANT_ID); > / > > *Running this script returns following output.* > > Table created. > > > Sequence created. > > > Trigger created. > > > Table altered. > > ALTER TABLE IDN_APPMGT_APP ADD CONSTRAINT APPLICATION_NAME_CONSTRAINT > UNIQUE(APP_NAME, TENANT_ID) > * > ERROR at line 1: > ORA-02261: such unique or primary key already exists in the table > > -- > Prasad Tissera > Software Engineer. > Mobile : +94777223444 > -- Prasad Tissera Software Engineer. Mobile : +94777223444
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
