AntiEarnie
Technical User
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_table
1) 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?
exp user/password@service tables=(test_table
1) file=test.dmp rows=yimp user/password@service2 tables=(test_table
1) file=test.dmp rows=ySame 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?
