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
- 14872 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is Tax Categories?
Explain prerequisites and post activities of oracle database installation
1. What is PO rate variance gain and loss?
What is an Oracle database Full Backup?
Explain about party and customer in ar : oracle accounts receivable
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
3. Steps in UAT?
What is the difference between recovery and restoring of the oracle database?
How many segment are present in Oracle Manufacturing
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
Explain the payment term in ar. : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : 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
Where in the Oracle directory tree structure are audit traces placed?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
