Dbms_metadat [message #671028] |
Fri, 10 August 2018 05:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/ba8968b33c00d460668ba9fc6854ba11?s=64&d=mm&r=g) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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.
|
|
|