Skip to Main Content
Forums

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!

Clarification on exp,expdp,imp and impdp while doing migration

user10719327Nov 3 2010 — edited Dec 7 2010
Hi All

We are doing database migration from IBM AIX to Linux Server.The Version is 11g.It was already confirmed that I need to use exp or expdp method for exporting db and imp/impdp for importing the databaseHere are my doubts.

1.Suppose if we are migrating the db using exp and imp.Can we go ahead for the full imp ie full=y while importing into Linux server.

a) If so , data dictionary will also imported,will it cause any problem or we can ignore it? or We have to do schema by schema.

Also please confirm the steps

b)I need to create the db on Linux server and need to create the tablespaces and user scripts also?

2.If we are using impdp ,do we need to create the tablespaces and users before importing from the import dump?

Thanks in advance
Veera
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2011
Added on Nov 3 2010
#database-and-application-migrations
2 comments
471 views