Skip to Main Content

Database Software

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!

exp express edition 10..2.0.1 to enterprise ed 11.2.0.1

785045Jul 27 2010 — edited Jul 28 2010
Hi. A department in our organization has a database they have buillt on a windows server with express edition 10.2.0.1. Out "normal" environment is all enterprise edition 11.2. The users want the database moved onto a "regular" and fully supported server. So I figured I'd create a new database, export the old one and import it into the new 11.2 databases. I have sql access to the windows environment. Anyway, firt I got that expdp wasn't compatible with their database. OK - so I figured I'd use the old exp/imp utilities. However I got an EXP-0008 telling me my client version of exp (from the 11.2 server) was not compatible with that version of the database.



If I am able to logon to the windows server - which I currently don't have access to - then I could run "exp" from that Oracle Home. I'd still need to transfer the file and then import it to the new database. However, would an 11.2 "imp" be able to process the file created from the earlier version?

So, I'm looking for the easy way around this. Suggestions?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2010
Added on Jul 27 2010
8 comments
1,574 views