A table is classified as a parent table and you want to drop and re-create it.

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?

Question Posted / guest

3 Answers
15184 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

A table is classified as a parent table and you want to drop and re-create it. How would you do th..

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

A table is classified as a parent table and you want to drop and re-create it. How would you do th..

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

A table is classified as a parent table and you want to drop and re-create it. How would you do th..

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

Post New Answer

More Oracle AllOther Interview Questions

How would you determine the time zone under which a database was operating?

1 Answers

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers

What is store procedure?and how do u take the values from database and run in scripts?

2 Answers Polaris,

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

0 Answers

What does coalescing a tablespace do?

2 Answers

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

0 Answers

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 Answers

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

0 Answers

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

0 Answers Cap Gemini,

What is auto invoicing? : oracle accounts receivable

0 Answers

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

0 Answers

how can we send a concurrent program output to the clients through mail or fax give me example.

1 Answers Cap Gemini,

For more Oracle AllOther Interview Questions Click Here