sangu_rao_at_yahoo.co.in wrote:
> Hi,
> I want to Partition an existing table which is having millions of
> calls. The table also has 4 indexes and lot of few constraints. What
> will be the best approach?
>
> I have explored on the ALTER TABLE ------ EXCHANGE option.
> When i do this i am getting some errors like
> ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
>
> As i mentioned my base table contains few indexes (one of the index is
> a unique index which has been created during the Primary key
> constraint) and constraints. I have created the Partitioned table also
> with the same syntax and with same Index and constraints. But still i
> am getting the above error.
>
> Can anyone please suggest me what could be the best approach to
> partition a table which contains Millions of rows and lot of indexes
> and constraints. Does the ALTER TABLE -- EXCHANGE PARTITION INCLUDING
> INDEXES export all the indexes and constraints along with the data from
> base table to destination table.
> How much time this exchange may take approximately if the table is
> populates with 1 million records.
>
> Please provide your suggestion
>
> Thanks
> Rao
>
dbms_redefinition. It can be done online.
Received on Wed Jan 10 2007 - 03:24:14 CST
