Home » SQL & PL/SQL » SQL & PL/SQL » Dbms_metadat (12c)
Dbms_metadat [message #671028] Fri, 10 August 2018 05:29 Go to next message
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 #671029 is a reply to message #671028] Fri, 10 August 2018 05:48 Go to previous messageGo to next message
gazzag
Messages: 950
Registered: November 2010
Location: Bristol, UK
Senior Member
Show us what you are doing.
Re: Dbms_metadat [message #671032 is a reply to message #671028] Fri, 10 August 2018 07:42 Go to previous message
joy_division
Messages: 4876
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.
Previous Topic: Spool Japanese Characters
Next Topic: How to Convert Row to Column As Below
Goto Forum:
  


Current Time: Wed Aug 15 23:10:16 CDT 2018