I think I found answer to move the index online to new tablespace
alter index SITEMON_PHP_SMTP_IX1 REBUILD PARTITION P_11022015 TABLESPACE
SITEMONTBS ONLINE
On Fri, Jul 21, 2017 at 11:16 AM, Vadim Keylis <vkeylis2009@xxxxxxxxx>
wrote:
1. I executed the following command to move table partition to new one:
ALTER TABLE SITEMON_PHP_SMTP MOVE PARTITION P_11022015 ONLINE
TABLESPACE SITEMONTBS UPDATE INDEXES;
2. select * from ALL_TAB_PARTITIONS where table_name = 'SITEMON_PHP_SMTP'
showed that partition of the table was moved to new partition. However
index remained in old tablespace.
How can I move index to new tablespace online as well?
On Fri, Jul 21, 2017 at 6:38 AM, Vadim Keylis <vkeylis2009@xxxxxxxxx>
wrote:
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