exp express edition 10..2.0.1 to enterprise ed 11.2.0.1
785045Jul 27 2010 — edited Jul 28 2010Hi. 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?