Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Full database export and import on another machine issue

630404Oct 16 2010 — edited Oct 16 2010

Hi Experts,

we are facing an issue regarding expdp and impdp.. we are migrating our OEM database (10.2.0.4)which is running on AIX 6.1 64bit box to same version of database that is newly created to box of Redhat Linux 4.8 32bit..when we export from AIX it i ok . but when we import it to Linux machines it give error for objects exsistence and most of objects fail to create during impdp..
i m using following commands to import and export
expdp system/password full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log

impdp system/password full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=impdpDB10G.log

can you please guide is it ok . or should i change my way to import to new database..please guide me

regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 13 2010

Added on Oct 16 2010

#general-database-discussions

3 comments

130 views