EXP utility of Oracle 9i [exporting oracle 8i data by sitting on oracle 9i]
Posted on 2004-11-23
i have some data in oracle 8i (126.96.36.199.0) in one server [S1] and i have oracle 9i installed in another server [S2]. I am sitting on S2 and made a tns from S2 for S1.
whenever i use exp utility from Oralce 9i [s2 server] to export the data of oracle 8i [s1 server], i failed and receive a message [ORA-02248: invalid option for ALTER SESSION]..
How can I resolve this? I heard it is not possible to export the data from upper to lower version.. Data is kept in lower version and i am exporting it from upper version's exp utility. It sounds very owkward that a user cann't export from upper to lower version.
Thanks in Advance