Re: Moving partition and non partition table online to a new tablespace in 12.1.0.1

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.

> 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_at_gmail.com>
> 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_at_gmail.com>
>> wrote:
>> >
>> > 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
>>
>

--
http://www.freelists.org/webpage/oracle-l