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
- 15063 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 domain in database and its benefits?
How do you switch from an init.ora file to a spfile?
Can we modify approve purchase order?if yes what is navigation?
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
as a technical developer in oracle applications which type errors feced in your experience sofar
What is autocashrule set? : oracle accounts receivable
What is difference b/w Credit memo and Adjustment in AR.
what are the advantages of Oracle over other databases..? please give me reply...
can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Give the reasoning behind using an index.
Oracle General 
