Use of undotbs in drop table


I want to drop a number of tables one after the other. The total data size is huge much higher than the undotbs table space. But each individual table is smaller than the undotbs.

My question is
1. Is undotbs or temp tablespace used when dropping tables.
2. Can there be a problem when the tables are huge.

Who is Participating?
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
1. No you do not need undotbs or temp tablespace for dropping tables.
2. No problems at all. The drop table command works fine as far as i have seen whether it is a big or small table.

All Courses

From novice to tech pro — start learning today.