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 / shailesh donda
1. DISABLE FOREIGN KEY CONSTRAINT
2. DROP THE PARENT TABLE
3. RECREATE THE PARRENT TABLE
5. ENTER THE MEANINGFUL DATA IN PARENT TABLE
4. ENABLE FOREIGN KEY CONSTRAINT
| Is This Answer Correct ? | 29 Yes | 5 No |
Post New Answer View All Answers
what are the API of GL,PO,AP
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
key flexfield structure
i want to know about the javaBean.what is its purpose and how it can use in Forms.
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
Can we modify approve purchase order?if yes what is navigation?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
as a technical developer in oracle applications which type errors feced in your experience sofar
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
What do you mean by Oracle MEDIA RECOVERY?
A scenario for amount correction & how to use amount correction functionality in AP invoices
Are These Dff's Flexible?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these