Hi, Sometimes you need moving tables and indexes to the new tablespace in Oracle.   Especially you want to drop any tablespace so you need to discharge or move all tables and indexes to the new tablespace.   You can move tables,partitions and subpartitions to the another tablespace in Oracle as follows. https://ittutorial.org/oracle-move-tables-partitions-and-subpartitions-another-tablespace-alter-table-move-tablespace-ora-14257/   You can … Continue reading How to Rebuild Unused Indexes or Move Another Tablespace in Oracle