OraFAQ Forum: Server Utilities » Using EXP utility from Oracle 9i to Oracle 8i

Home » RDBMS Server » Server Utilities » Using EXP utility from Oracle 9i to Oracle 8i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Using EXP utility from Oracle 9i to Oracle 8i [message #74352]

Mon, 22 November 2004 22:17

Zeeshan Amjad
Messages: 2
Registered: March 2003

Junior Member

i have some data in oracle 8i (8.1.5.0.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.

Report message to a moderator

Re: Using EXP utility from Oracle 9i to Oracle 8i [message #74354 is a reply to message #74352]

Mon, 22 November 2004 23:13

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

See Metalink Note:132904.1:

"Export the data with the Export utility of the lowest database version involved."

"Import the data with the Import utility of the target database."

Best regards.

Frank

Report message to a moderator

Previous Topic:	Re: IMP-00069 Error
Next Topic:	incremental export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 08:40:17 CDT 2024