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: 955
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: 4879
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: Fri Aug 17 14:22:56 CDT 2018