MySQL Forums
Forum List  »  Partitioning

Re: EXCHANGE PARTITION and DATA DIRECTORY errors
Posted by: Ekundayo Lasode
Date: August 19, 2014 06:28AM

Thanks for the reply Mattias.

Partitioned tables are one of the use limitations for the first option and we can't avoid partitioning because of the sheer size of the database (about 22GB per monthly partition for just 1 table!)

I might have to play with v5.7 to see what's possible. Unfortunately "ALTER TABLE IMPORT PARTITION TABLESPACE" still requires physically copying gigabytes of data on disk to be imported @ the destination schema/server.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: EXCHANGE PARTITION and DATA DIRECTORY errors
1149
August 19, 2014 06:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.