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
- 13709 Views
- I also Faced
- E-Mail Answers
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? : oracle accounts receivable
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What is Restricted Mode of Instance Startup in Oracle?
What is the difference between oracle media recovery and crash recovery?
What is mrc and what is its use? : oracle accounts receivable
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?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Give two methods you could use to determine what DDL changes have been made.
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
How many segment are present in Oracle Manufacturing
What is the mandatory setup in cyclecount ?
