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
- 13701 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
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What is auto invoicing? Explain : oracle accounts receivable
3. Steps in UAT?
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?
types of receipts and detail desription about recipts and tables effected by receipts?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Where in the Oracle directory tree structure are audit traces placed?
Difference between negative and positive adjustments : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
