Home » RDBMS Server » Server Administration » Installing Oracle client
Installing Oracle client [message #175482] Fri, 02 June 2006 08:02 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
Hi ,

we have 9.2.0.1.0 client installed in windows box.
we have the 9.2.0.7.0 server in Linux box.

Since the export taken at client side fails with the error as follows

EXP-00003: no storage definition found for segment(6, 49)

I googled metalink and found that lower client version is used to take the export of the database of version greater than 9.2.0.5.0.

So we need to upgrade the client or to install higher version client.

where to get the higher version client software and how to proceed..?


regards
bala
Re: Installing Oracle client [message #175484 is a reply to message #175482] Fri, 02 June 2006 08:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you search here?
http://www.orafaq.com/forum/?t=rview&goto=167881#msg_167881
Re: Installing Oracle client [message #175504 is a reply to message #175484] Fri, 02 June 2006 09:27 Go to previous messageGo to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
yes..i found that the versions are different in my case with server 9.2.0.7.0 and client 9.2.0.1.0.

only if the versions are same and are above 9.2.0.4.0 , we could change catexp.sql.

In my case , the versions are diff.

So how to get rid of the issue..?

regards
bala
Re: Installing Oracle client [message #175506 is a reply to message #175504] Fri, 02 June 2006 09:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Use lower version to export and import.
Or
The same procedure should work.
>> only if the versions are same and are above 9.2.0.4.0 , we could change catexp.sql.
Where did you get that?
If versions are same, nothing needs to be done.
Re: Installing Oracle client [message #175809 is a reply to message #175506] Mon, 05 June 2006 08:11 Go to previous message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
we need to use client of 9.2.0.1.0 to take the export of the database having version 9.2.0.7.0.

In that case , we need to have the higher version in the client side to do the job...

so how to get rid of the issue...?

Plz guide..

regards
bala
Previous Topic: Import problem. need help
Next Topic: Connection with MS Excel
Goto Forum:
  


Current Time: Fri Sep 20 11:35:12 CDT 2024