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
- 13752 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / hitesh
or we can also use ondelete cascade option while creating
table.using this help as to delete or change the data
easily in parent
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / 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 |
When a user process fails, what background process cleans up after it?
How would you go about increasing the buffer cache hit ratio?
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
You have just compiled a PL/SQL package but got errors, how would you view the errors?
What are the main diff. between oracle 7.3 and oracle 8i?
What does coalescing a tablespace do?
Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance
please explain about oracle
1. What is PO rate variance gain and loss?
What is auto invoicing? : oracle accounts receivable
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
what are the advantages of Oracle over other databases..? please give me reply...
Oracle General 
