Skip to Main Content

Export a PK with autocreated index.

user2094682Oct 23 2013 — edited Oct 24 2013

Im using SQLDeveloper  Versión 3.2.20.09

Is there a way of generate an export DDL script to preserve the original authomatic created index of a primary key?. When I generate the export DDL script it always generates explicit indexes no matter if they were originally created implicity or explicity.

My problem is related whit this migration issue https://forums.oracle.com/message/1223619#1223619 but in my case I'm using the script on a different instance with the same versión of Oracle (10.2g). I know that using explicit DROP INDEX option on ALTER DROP statement resolves the problem, but I thought tha withthe export facility, I'd have exactly the same DB on both servers.

Thanks in advance.

Comments
Post Details
Added on Oct 23 2013
2 comments
267 views