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
- 14989 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 are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
Difference between transaction type and transaction sources. : oracle accounts receivable
how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
key flexfield structure
Give two methods you could use to determine what DDL changes have been made.
pl help me, i want oracle HRMS training institute address,in chennai
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
How client makes connection with server in client/server architecture?
Compare and contrast TRUNCATE and DELETE for a table.
Explain prerequisites and post activities of oracle database installation
how can it possibble to see the report output in excel sheet in oracle applications
Oracle General 
