What happens to indexes if you drop a table?
- 1 Answers
- 1248 Views
- I also Faced
- E-Mail Answers
Answer / Mrs Madhu
When you drop an Oracle table that has indexes, the associated indexes are not automatically dropped. You must explicitly drop the indexes using the DROP INDEX command. If you want to drop both the table and its indexes at once, you can use the DROP TABLE cascade command.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to select some rows from a table in oracle?
Which Oracle App Is Most Popular One ?
How to load data from external tables to regular tables?
What is bind variable in oracle 11g?
Explain oracle instance.
Explain the use of tables option in exp command.
What is not equal to in oracle?
How to assign values to variables?
how to find find & delete duplicate rows from two different tables?
Give the constructs of a package, function or a procedure.
Explain the use of grant option in imp command.
How to define a sub function?
Oracle General 
