Shrinking tablespace and dropping datafiles with small amount of data
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