CODE EXAMPLE FOR SQL

export partttion and import in oracle

expdp jagruti/oracle directory=DIR_PART dumpfile=expdp_partition.dmp logfile=expdp_partiiton.log tables=TRANSACTIONS_MAIN:Y_2015

Y_2015 - partition name

impdp jagruti/oracle directory=DIR_PART dumpfile=expdp_partition.dmp logfile=impdp_partiiton.log tables=TRANSACTIONS_MAIN:Y_2015 TABLE_EXISTS_ACTION=APPEND