Moving data between different versions of the Oracle database

The point is: if you move data from a higher version DB to a lower version DB, then you have to use for both export and import the utilities of the lower version DB. If you are moving data "up" between versions, then export with the EXP utility of the source DB and import with the IMP of the destination DB.

I'm doing such data moving quite rarely (once in one or two years) and always had to rediscover the know-how over and over again. Hopefully I'll remember it now that I made this note in my blog. Smile

The info came originally from AskTom.