I have a 126.96.36.199.0 database (so no patches installed) and I created an dump file. Our client has a 188.8.131.52.1 version and has a problem importing my dump file. Is it possible that the problem is caused by the "version difference" or could it be something else?
thanks for the reaction, but my client has solved the problem after trying for a while (i'm still waiting to see what was actually the error), but I would like to make my question a little broader, namely what versions are supposed to be "compatible". Is it possible (maybe with some minor changes to be applied) to connect between 8.0 versions or between two 8i versions or between 8.0 and 8i. If not, what is causing the problem?
1. When exporting use the lower version of exp utility from the two Oracle versions. For example if you have 8.0.5 and 8.1.7, and you want to export 8.0.5 - then export with 8.0.5 exp by connecting to the 8.0.5 locally. If you want to export 8.1.7, then use the 8.0.5 exp again but login into the 8.1.7 db with TNS alias remotelly.
2. When importing the rule is reverse - to import 8.0.5 db - export with 8.0.5 exp and import with 8.1.7 imp.
What I actually meant was, can I "always" import/export between 8.0s (lets say 8.05 and 8.06)? And can I always import/export between 8.1s (for example 8.1.5 and 8.17) or do these utilities change with every new version that is released by Oracle?