I can't run the import/export utility wizard. I'm trying to export an Oracle 8.05 database, but I have 9i Oracle client on my PC(operating system windows xp).
I get the following error :
Export: Release 188.8.131.52.0 - Production on Jue Jun 12 16:15:19 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
EXP-00056: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION
EXP-00000: Export terminated unsuccessfully
This is an Oracle client/database limitation.
The following link is to an Oracle doc that describes "Using different releases and versions of export". It notes that, "the version of the Export utility must be equal to the lowest version of the source or target database." The export utility is related to your client version.
Install a client is equal to, or lower than the lowest version of your source or target database.
Trying to export an 8i database requires at most an 8i client. Using a 9i client or greater will result in error.