Database Utilities (MOSC)

MOSC Banner

Exporting and import table partition data from one table to a different table in 11g

edited Sep 20, 2017 4:11PM in Database Utilities (MOSC) 5 commentsAnswered

I have a table with about 52 partitions that I want to export about 20 of partitions and data to a another table in the same schema.   The target table already exist without the partitions that are being imported in.

I was able to successfully export the table partitions with the following command:

expdp eta_user/********* directory=data_dump dumpfile=history_partition_2015.dmp tables=analog_history:P2015_W11,analog_history:P2015_W12,analog_history:P2015_W13,analog_history:P2015_W14,analog_history:P2015_W15,analog_history:P2015_W16,analog_history:P2015_W17,analog_history:P2015_W18,analog_history:P2015_W19 logfile=analog_history_partition.log;

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