Re: EXCHANGE PARTITION and DATA DIRECTORY errors
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.
Subject
Views
Written By
Posted
4129
August 16, 2014 09:47AM
1898
August 19, 2014 03:32AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors
1726
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.