Home » Unlabelled » A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables? | Oracle 10g Interview Questions
Friday, 2 November 2012
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables? | Oracle 10g Interview Questions
Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.
No comments:
Post a Comment