Exporting/Importing partitioned table [message #594766] |
Mon, 02 September 2013 11:12  |
srivaths
Messages: 60 Registered: June 2005 Location: France
|
Member |

|
|
Hi,
I am trying to export a partition of a table and import it to another database. I get the below error when I try to import.
ORA-14400: inserted partition key does not map to any partition
If I export the table(for that particular partition) and import the table(after dropping the table) in destination, the partitions and subpartitions are created without any problem.
The table is Range Partitioned and Subpartitioned in List.
So I had to perform the below operation if I want to retain other data in the Destination table.
1. Drop the existing partition
2. Create the partition and subpartition, same as source
3. Execute imp
Infact I had to perform step#2, as if I split the parition also, the subpartition gets replicated in the new partition, which again throws the same error.
Is there better way of managing the partitions and subpartition in destination with exp/imp utility, so that I need not perform step#1 and step#2 manually.
Regards
Srivaths
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Exporting/Importing partitioned table [message #594980 is a reply to message #594979] |
Wed, 04 September 2013 10:23  |
srivaths
Messages: 60 Registered: June 2005 Location: France
|
Member |

|
|
We have already achieved around 20% gain from exp/imp for the same set of data performed over DBLINK. But I am trying to find a better way of handling the partitions in the destination table.
As Oracle does manage the partitions/subpartitions when a full table is imported, but NOT when I am trying to import a particular partition.
|
|
|