Tag Info

New answers tagged


If the USING INDEX clause is omitted, the index will be still created automatically with the same name as the constraint, in the same tablespace where table is created. This will not cause an error. http://docs.oracle.com/database/121/SQLRF/clauses002.htm#SQLRF52225 If you specify schema.index, then Oracle attempts to enforce the constraint using ...

Top 50 recent answers are included