Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 14873 Views
- I also Faced
- E-Mail Answers
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 interface tables used for ar invoices, customers, receipts for conversion process? : 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?
how to replace not in with not exist?
Difference between negative and positive adjustments : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
What is the sql query to find the employee who has Nth maximum salary?
as a technical developer in oracle applications which type errors feced in your experience sofar
what are the tools used for oracle 10g in real time.
What is the mandatory setup in cyclecount ?
What is autocashrule set? : oracle accounts receivable
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
1. What is PO rate variance gain and loss?
