SQL & PL/SQL

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!

How to "extract" all constraints

694243Jan 5 2010 — edited Jan 5 2010

Hello,

I need a query that can "extract" all constraints from a schema. The goal is to install and enable the constraints on another schema having the same structure (tables).

I know that I can achieve this with TOAD, just by clicking on "Create script". Unfortunately I don't have TOAD, so I need another way...

Thanks in advance!

This post has been answered by Sarah_7 on Jan 5 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2010

Added on Jan 5 2010

5 comments

2,522 views