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!

Imp 9.2 file into 11r2

epipkoMay 21 2018

I am upgrading 9.2.0.8 to 11.2.0.4 via exp/imp as d/b size is only 180Gb.

I installed 11.2.0.4 on a new server. I understand I have to create new database before importing dmp file.

Do I need to create tablespaces/data files before import as well?

Also, here is how I exported 3 users: 

exp userid=system/derp file=d:\tmp\derp_exp.dmp owner=A, B, C statistics=none log=d:\tmp\derp_exp.log

Can I import it as:

imp system/derp file=d:\tmp\derp_exp.dmp full=y log=d:\tmp\repd_imp.log

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2018
Added on May 21 2018
#database-upgrade
0 comments
152 views