Skip to Main Content

Oracle Database Discussions

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!

Create constraints based on another table

407048Jun 21 2004 — edited Jun 22 2004
I have a table X from which I created another table Y, by doing

Create table Y as select * from X;

Table X has 12 constraints when I queried the user_constraints table. Table Y has none now.
I need the table Y to have the 12 constraints that table X has. How can this be achieved and what is the best method to do this ?

Thanks




Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2004
Added on Jun 21 2004
5 comments
229 views