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
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
