drop table question

[leonard905]

Hi,

If you have 2 databases (A & B) on the same server, and you drop a table in database A, is this space available to database B. If not, how can you make space available to other databases from dropping objects in one.

Thanks

[stecal]

No.

Resize datafiles/tablespaces.

[sreddy]

Its available if you meet following conditions:

- The datafile of 'A' where the table has been dropped needs to be resized (if it can be resized to reclaim the space occupied by the table dropped)
- The datafile of 'B' (assuming table in 'B' need more space) should available on the same filesystem.