Skip to Main Content

Export a PK with autocreated index.

user2094682Oct 23 2013 — edited Oct 24 2013

Im using SQLDeveloper  Versión

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 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.

Post Details
Added on Oct 23 2013