Export/Import database/schemas with partition tables in 9i
I have a scheduler to export my db every day (I have been used 9.2.0.4 64 bit on AIX). And sometime I use it to import to other machine. Exporting and importing are ok.
But when I partition some tables, exporting is normal no problems. But when I import to others machine, oracle did not import these partition tables. I used bellow scripts to export and import dump file.
exp userid=system/xxx file=..... owner=ABC indexes=y constraints=y
imp userid=system/xxx file= .... fromuser=ABC touser=ABC ...
After that, I exported these partition tables with TABLES=ABC.part_1, ABC.part_2 and import to other machine. ==> It ok !