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.