Export table , Import into partitioned table
Hello everyone
We have 2 databases; both are 11.2.0.2
DB # 1 has a table (TAB-NON-PART) with DATE column and it has yearly data from 2010 thru 2013
On DB # 2, we are planning to create the same table but with RANGE partitioned on DATE column (called TAB-PART) so that there is a partition for each year
If we export the (non partitioned) table from DB # 1 and import it into partitioned table on DB # 2, would oracle
automatically handle properly importing the data into various partitions on the partitioned table?
We will of course, pre-create the partitions (P_2010 thru P_2013) on the DB # 2 before running data pump Import
We have 2 databases; both are 11.2.0.2
DB # 1 has a table (TAB-NON-PART) with DATE column and it has yearly data from 2010 thru 2013
On DB # 2, we are planning to create the same table but with RANGE partitioned on DATE column (called TAB-PART) so that there is a partition for each year
If we export the (non partitioned) table from DB # 1 and import it into partitioned table on DB # 2, would oracle
automatically handle properly importing the data into various partitions on the partitioned table?
We will of course, pre-create the partitions (P_2010 thru P_2013) on the DB # 2 before running data pump Import
0