Database Administration (MOSC)

MOSC Banner

resize datafiles after moving tablespace objects

I'm not able to resize datafiles of a tablespace

as in the tablespace there is a lot of free space I would to disallocate it

so I moved all objects in the tablespace (table, table partition, lobsegment, lob partition) and a I rebuild all indexes and index partitions located in the tablespace

At the end I only could do some very small resize (I have more than 1T of free space and I was able to recover few GBs)

isn't enough moving objects to recover free space ?

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