working at apex.oracle.com
created a unique index on a table CF_INVESTORS (user_id)
now creating a foreign key on another table CF_DEPWIT referencing above table and unique index column, below are both statements, it is showing error subject mentioned.
CREATE UNIQUE INDEX "CF_INVESTORS_IDX1" ON "CF_INVESTORS" ("USER_ID")
/
alter table "CF_DEPWIT" add constraint
"CF_DEPWIT_CON" foreign key ("INVESTOR_ID") references "CF_INVESTORS" ("USER_ID")
/
what is wrong here ? or something i missed? please help.
regards