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 Interview Questions and Answers (Part 5)
(Continued from previous question...)
740. 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?
Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.
(Continued on next question...)
Other Interview Questions