Dbms_metadat [message #671028] |
Fri, 10 August 2018 05:29 |
|
Kannan Oracle
Messages: 1 Registered: August 2018
|
Junior Member |
|
|
We are migrating to 12c and observed that while generating ddl for primary key constraints it shows the create index statement as well.
We want to have it as alter table tabname constraint without create index command inside the ddl.
In 11g it generates without create index statement.
|
|
|
|
Re: Dbms_metadat [message #671032 is a reply to message #671028] |
Fri, 10 August 2018 07:42 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Sometimes a PK constraint is created using a non unique index. Otherwise, creating a PK constraint will create an index.
|
|
|