Good evening Oracle Experts.
We are using Oracle 12.1.0.1 Enterprise Edition. I have multiple
1T highly transactional partition table which I need to move to new table
space. I would like to move partitions online. Will the tables available
for inserts and update during the move to new tablespace? Will I need to
rebuild indexes after table is moved to new tablespace or that will be
taken care by database? What issues can I encounter while moving partition
table online?
Can I move non partition table to new partition online?
Greatly appreciate your guys help,
Vadim