Oracle Database Discussions

Hi,

We have a table (table t) with partitions (p1, p2, ... p12) and two of the partitions (p11 and p12) need to be imported into

another database with different schema. Both the partitions to be imported are in two different export dumps. So, I started

by dropping the table t and then import with the first export dump (p12). The first import went fine, but the second import

failed with error:

IMP-00058: ORACLE error 14400 encountered
ORA-14400: inserted partition key does not map to any partition
IMP-00057: Warning: Dump file may not contain data of all partitions of this table
About to enable constraints...
Import terminated successfully with warnings.

The imp command used is:

imp user/pwd tables=t log=imp.log file=exp.dmp fromuser=db1user touser=db2user ignore=Y grants=n indexes=n constraints=n

statistics=none

Please let me know where is the problem and what is the solution? I need to import the second partition (p11) also

successfully.

Thanks.

BNetra