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
- 13683 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 |
WHAT IS CARTESIAN PRODUCT?
How to find locks exists in a table or not?
Explain about party and customer in ar : oracle accounts receivable
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
what is difference between inner join & nested query or subqueries
what is shared memory?
what is semphore explian it?
can u give guidance abt packages of plsql
What is mrc and what is its use? : oracle accounts receivable
i have marks in table,how to find total?
What is supporting issues GL AP and AR?
What is chargeback invoice? How do we create it? : oracle accounts receivable
Oracle General 
