Oracle Database Discussions

Hi fellows,

I am using Oracle Database 10.2.0.5

In this environment we are not using archive log.

I will load some data from a production to development environment, using datapump. This data belongs to a single schema, and that schema already exists in development env. but the data in development env. is too old, i just have to 'update' the data.


Here's my doubt:
I will drop all objects from this schema in develop. env. and after this i will import the data. I have low space in the disk, but after the drop, some datafiles suppose to get empty, and the data that will be imported should fulfill the tablespaces and i would not have to allocate more space to this tablespaces.
The question is, when i drop the objects, it will release the space instantly ?

I am concerned about this, because if i drop the schema, try to import it, and fails because of tablespace burst, it will be a big problem for me, because i have no more space on the disk to allocate for datafiles.

Thanks in advance, any precisely information about this will be appreciate.

Regards,