Unique index

5 views
Skip to first unread message

Konstantin Tokar

unread,
Apr 4, 2015, 9:11:21 PM4/4/15
to rose-db...@googlegroups.com
Hi!

Oracle 11g:

What is the difference between defining unique columns:

1) CREATE UNIQUE INDEX IDX_CTE_PORT_2 ON CTE_PORT ("CODE")   ;
2) ALTER TABLE CTE_PORT ADD CONSTRAINT "IDX_CTE_PORT_2" UNIQUE ("CODE");


After starting the Loader, the first definition does not lead to the creation of unique_key => ['CODE'], the definition of uniqueness through constraint Loader works correctly.
Can I do something to Loader to work properly with a unique index?

--
Konstantin Tokar
Reply all
Reply to author
Forward
0 new messages