Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datapump sqlfile option to extract only PK

rcc50886Jul 19 2012 — edited Jul 19 2012
Is there any way to generate a sqlfile using Datapump that contains only Primary Key (I don't want the Check and Foreign Key constraints)

There are lot of Chk and Fk, so editing is not an option

I am able to generate the FK script by using " include=CONSTRAINT/REF_CONSTRAINT "

Is there any way to extract only PK DDL's ??

-Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2012
Added on Jul 19 2012
#database-key-features, #export-import-sql-loader-external-tables
11 comments
2,894 views