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
15190 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 to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers Alshaya,

Describe the P2P cycle ?

1 Answers

What is the difference between recovery and restoring of the oracle database?

0 Answers

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

0 Answers

A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers

When creating a user, what permissions must you grant to allow them to connect to the database?

4 Answers

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

0 Answers

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 Answers IBM, Oracle,

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

0 Answers HP,

What Are Cross Validation & Adi?

0 Answers Oracle,

How to clone the database using RMAN back

0 Answers

Give the two types of tables involved in producing a star schema and the type of data they hold.

1 Answers

For more Oracle AllOther Interview Questions Click Here