Database Administration (MOSC)

MOSC Banner

Shrinking tablespace and dropping datafiles with small amount of data

edited Feb 17, 2015 10:00AM in Database Administration (MOSC) 3 commentsAnswered


Greetings,

   I am looking to shrink the database 11.2.0.2 tablespace APPS_TS_TX_DATA and along the way reduce the number of database files specially tablespace-files that are small or contain little amount of data without loss of data or cause of corruption. I would prefer an online solution if available. Meanwhile, my understanding is that the command "ALTER DATABASE DATAFILE ... RESIZE ..." is the only available option to reduce the size of the tablespace (none temporary tablespace) and we have a large amount of data files created over the years. What action plans you would recommend that we adopt to achieve

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