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?
Answer Posted / sandra
drop foreign key constraint
drop parent table
recreate parent table
alter child table add foreign key
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain the use of table functions.
How would you determine who has added a row to a table?
Is there any link between pr form(purchse requisition)and po form(purchase order)
What is the importance of batch source set up in ar? : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar
What is the difference between oracle media recovery and crash recovery?
Explain about party and customer in ar : oracle accounts receivable
where the dff data will be stored
what are basic modules required to implement oracle application in any oraganisation?
Why more redos are generated when the oracle database is in begin backup mode?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Are These Dff's Flexible?
HOW TO SPOT AHIERARCHY?
how to replace not in with not exist?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?