Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

space not reclaimed afre dropping user

668822Sep 14 2009 — edited Sep 14 2009

hello all,

OS:- RHEL 5.2
database:- oracle 10.2.0.1

i dropped a user from my database due to lack of space on partition.but it didn't reclaim space in database and keep telling the space space on partition...i tried alter tablespace colesce but same result as it is having multiple datafiles i am unable to know which datafile to resize..

i also purge recyclebin, but no luck, how can i reclaim space on tablespace level???? i also tried resize for database but got

ORA-32773: operation not supported for smallfile tablespace USERS

so any suggestion will be appreciable, that user was occupying 4 GB of space and i dropped it, but still unable to reclaim space..how can i do that???

thanks and regards
VD

This post has been answered by Hemant K Chitale on Sep 14 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2009

Added on Sep 14 2009

#general-database-discussions

19 comments

10,044 views