Home » RDBMS Server » Server Utilities » migrate from 10g to 9i, with LOB objects ??
migrate from 10g to 9i, with LOB objects ?? [message #236872] Fri, 11 May 2007 03:24 Go to next message
smundaye
Messages: 4
Registered: May 2007
Location: mumbai
Junior Member
Hey gurus,

Can anyone tell me is it possible to move all data from 10g database to 9i, with LOB objects ?? And if yes, then how do i do it ??
I did export using 9i client, which gave error EXP-00003. While searching on net I came to know that there is a problem while migrating from 10g to 9i, if u have LOB objects. So wanted to know if there is a way out.
Re: migrate from 10g to 9i, with LOB objects ?? [message #236931 is a reply to message #236872] Fri, 11 May 2007 06:30 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Best would be to log a SR (TAR) with Oracle Support:

00003, 00000, "no storage definition found for segment(%lu, %lu)"
// *Cause:  Export could not find the storage definitions for a cluster,
//          index, or table.
// *Action: Record the accompanying messages and report this as an Export
//          internal error to customer support.


PS: Whay ould you like to move back to 9i? 10g is much better than 9i!
Re: migrate from 10g to 9i, with LOB objects ?? [message #236936 is a reply to message #236931] Fri, 11 May 2007 06:47 Go to previous messageGo to next message
smundaye
Messages: 4
Registered: May 2007
Location: mumbai
Junior Member
No no, I am not thinking to move back. And I agree, 10g is far better than 9i. But, since we have problem with available resources, I have to shift to 9i. So is it possible ??
Re: migrate from 10g to 9i, with LOB objects ?? [message #237235 is a reply to message #236936] Sun, 13 May 2007 11:35 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
YOu should fellow "Frank" suggestion and log TAR with Oracle Support.


Regards
Taj
Previous Topic: sql loader help
Next Topic: Ora errors while calling a funtion
Goto Forum:
  


Current Time: Wed Dec 25 12:18:25 CST 2024