Database Utilities (MOSC)

MOSC Banner

Export/Import database/schemas with partition tables in 9i

edited Aug 1, 2012 2:05AM in Database Utilities (MOSC) 4 commentsAnswered
Hi all,

    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 !

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center