importing table partition
420827Feb 8 2007 — edited Feb 8 2007Hello all.
I want to import only one partition of a table. The export that i have done is :
exp usernmae/pass tables=(table_name:partition_name) ....
And i want to import this partitino to another server with the same table_name.
What can i do, i have first to create the partition to the target table and use import utility Or i directly use import utility and import will create first the partition.
What the way to import it.
Because when i import it directly i had an error like this:
. . importing partition "TABLE_NAME":"PARTITION_NAME"
IMP-00058: ORACLE error 14400 encountered
ORA-14400: inserted partition key does not map to any partition
Import terminated successfully with warnings.
Thanks for your help.
raitsarevo