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?
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 is the use of lockboxes? Steps for lock box : oracle accounts receivable
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.
3. Steps in UAT?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is the difference between recovery and restoring of the oracle database?
What is auto invoicing? Explain : oracle accounts receivable
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is the difference between conversions and interfaces? : oracle accounts receivable
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
i want to know about the javaBean.what is its purpose and how it can use in Forms.
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?