When I drop tables in a plsql procedure, the tablespace is not increasing and I am running out of tablespace before the procedure finishes. I have no control over the tablespace limit allocated to me. Is there a way to force the tablespace to be updated while the procedure is still running ???

I expected the tablespace to be updated as soon as the DROP TABLE statement was executed but it is definitely not happening until the procedure comes to an end!