Database DataWarehousing (MOSC)

MOSC Banner

Export table , Import into partitioned table

edited May 29, 2013 9:35PM in Database DataWarehousing (MOSC) 4 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center