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
What is the disk migration? what is the steps involved in oracle disk migration?
What is the mandatory setup in cyclecount ?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
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?
Is there any link between pr form(purchse requisition)and po form(purchase order)
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
Are These Dff's Flexible?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
What is chargeback invoice? How do we create it? : oracle accounts receivable
Explain how to close periods in ar. : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable