Create constraints based on another table
407048Jun 21 2004 — edited Jun 22 2004I 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