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
- 15074 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 ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What is difference b/w Credit memo and Adjustment in AR.
what is sql*loader parameters and where we will use it.
Explain the use of table functions.
Describe the P2P cycle ?
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
can u give guidance abt packages of plsql
Are These Dff's Flexible?
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
What are different types of transactions in ar? : oracle accounts receivable
What is supporting issues GL AP and AR?
Oracle General 
