Importing a Partition

[AntiEarnie]

I'm a bit confused on this. First off I tried exporting just one partition. According to the feedback I got the right number of rows exported. However, when I try to import the partition that I just exported I get an IMP-00055 partition not found in export file. I used the following format:

exp user/password@service tables=(test_table1) file=test.dmp rows=y

imp user/password@service2 tables=(test_table1) file=test.dmp rows=y

Same user and target table on two different services. Only real difference is that the import target table does not contain a partition P1, It does however contain several other partitions. Using Oracle 8.1.7 on Windows 2000 Server.

Anyone got an idea why I would get a imp-00055 error on this?

 

[did02]

Hi,

If your partition does not exist in the target table and you don't want to create it, just import without specifying the partition (I'm not sure it works).
Else, create the partition in the target table and then import data.
Last solution, back up your target table and drop it. Then import data (imp should create the table with the partition)
Rgds,
Did02