Database Administration (MOSC)

MOSC Banner

Dropping partition did not free up space

edited Apr 9, 2013 1:56PM in Database Administration (MOSC) 8 commentsAnswered
 I just dropped two partitions in a table.alter table SNG.TIMELINE_COLLECT drop partition P2010_09;
alter table SNG.TIMELINE_COLLECT drop partition P2010_10;

The database is on ASM. I need to claim the space back to ASM. There are two tablespaces associated with the two partitions. They are
TIMELINE_COLLECT_D_P2010_09 and TIMELINE_COLLECT_D_P2010_10.
Should I drop them to claim back the space? it looks like the tablespaces have 49MB out of 2GB.
But there is no table or index in those tablespaces.

What is the best way?
Thank you.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center