Did anyone used the following approach?:
ALTER TABLE t1 MOVE PARTITION part_2015 ONLINE TABLESPACE users UPDATE INDEXES;
On Jul 21, 2017 5:44 AM, "Karthikeyan Panchanathan" <keyantech@xxxxxxxxx>
wrote:
Vadim
Handled similar issue before and this is how handled it. You options may
different here.
One month prior go-live, we created replica tables (as _NEW) in new table
space.
Ran daily job to copy history partitions data( data never change) from
current to _NEW table. This includes copying data to staging table, build
indexes and swap partitions.
On Go-Live day copy only latest partitions and renamed current as old and
_NEW as currrent.
HTH
Karth
On Jul 21, 2017, at 2:00 AM, Vadim Keylis <vkeylis2009@xxxxxxxxx> wrote:multiple 1T highly transactional partition table which I need to move to
Good evening Oracle Experts.
We are using Oracle 12.1.0.1 Enterprise Edition. I have
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