Skip to Main Content
Forums

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 Copy all list of constraints into New schema from Old Schema

Sekhar ReddyMar 22 2016 — edited Mar 22 2016

Hi All,

I have around X number of constraints in Schema: OLD and i have recently created a new schema : NEW similar to  OLD schema. Without any Data, Constraints, Indexes.

Now, I want to create all X number of constraints in NEW schema with a single script.

Is there any approach.

Thanks in Advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2016
Added on Mar 22 2016
5 comments
724 views