rohit_kapil
asked on
Use of undotbs in drop table
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.