This content has been marked as final. Show 2 replies
does it exports tables structure also or does it only exports the data stored in that partitions.It will try to create the table (with create table statement including all partitions) and then do import of partitions data from the dump file. So if table is already there, it will return error and may keep on importing data, but, you need to manually create those partitions in the destination table which are being imported (if these partitions don't exist already).
impdp dumpfile=x.dmp log=y.log tables=user1.table1:partition11, user1.table1.partition2You need to create partitions manually before importing if these partitions don't exist already.
and this table partitions are in different tablespaces. so does we need to create all the tablespaces and partitions on that target side also.As told above, you need to create these partitions manually as import process will not create this partitions, you can create them any where in the database before import.