We help IT Professionals succeed at work.

Use of undotbs in drop table

rohit_kapil
rohit_kapil asked
on
Hi,

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.

Thanks
Comment
Watch Question

Production Manager / Application Support Manager
CERTIFIED EXPERT
Commented:
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.

Thanks

Explore More ContentExplore courses, solutions, and other research materials related to this topic.