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

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_at_gmail.com> 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_at_gmail.com>
> 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_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