Database Utilities (MOSC)

MOSC Banner

Datapump import partitions

edited Jan 21, 2015 10:01AM in Database Utilities (MOSC) 1 commentAnswered

Hi,

I have both source and target databases are running on 11.2.0.3. In the source database, I have a table called EMPDATA with partition part_jan, part_feb, part_mar, part_apr, part_may, and part_june.

In target database I have the same table name (EMPDATA) with partition part_jan, part_feb, and part_mar. Now I want to export partitions part_apr, part_may and part_june from source to target database.

I know if i used datapump export table_exist_action with append the partitions will not be created in target database table, I would want to import those data together with partitions created.

Tagged:

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