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
- 14871 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 |
Explain how to close periods in ar. : oracle accounts receivable
What is the difference between the SQL*Loader and IMPORT utilities?
how can it possibble to see the report output in excel sheet in oracle applications
what are basic modules required to implement oracle application in any oraganisation?
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
How do you resize a data file?
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value
can we use lexical perameter in oracle plsql if yes how
What is the use of lockboxes? : oracle accounts receivable
Where would you look for errors from the database engine?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
Oracle General 
