Database DataWarehousing (MOSC)

MOSC Banner

Partitioning tablespace impact on data purging

edited Nov 12, 2014 4:23PM in Database DataWarehousing (MOSC) 3 commentsAnswered

DB is Oracle Enterprise 11.2.0.3 edition

tablespace stats has multiple tables which in turn have multiple partitions.

Goal is to reclaim space on server.

I wish to drop a number of partitions from tables A,B,C, all tables reside in tablespace stats.  Other tables also reside in tablespace stats.

1. is it better to truncate the partitions to insure that the data is deleted rather than just drop the partitions?

2. do I then coalesce the tablespace to reclaim the newly freed space in stats?

Thanks,

Janet

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