Home » Other » General » Oracle DB migration (Oracle 9i to 10G)
Oracle DB migration [message #391001] Tue, 10 March 2009 11:20 Go to next message
Gana13
Messages: 9
Registered: November 2008
Junior Member
Hi All,

Suppose we are developing some application with Oracle DB or oracle front end (forms) in oracle lower version like 9i.
In what case and all, we can not migrate the applicaions to oracle higher version like 10g.

Thanks & Regards,
Ganapathy.S
Re: Oracle DB migration [message #391002 is a reply to message #391001] Tue, 10 March 2009 11:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
When it is not supported, it is one case.

Regards
Michel
Re: Oracle DB migration [message #391005 is a reply to message #391002] Tue, 10 March 2009 11:33 Go to previous messageGo to next message
Gana13
Messages: 9
Registered: November 2008
Junior Member
Hi,

i am asking generally..
is thre any certain cases, if we use that while devoping applicatin with oracle 9i... So because of that, we can not migrate it to oracle 10g later on...

Ganapathy.S
Re: Oracle DB migration [message #391129 is a reply to message #391005] Wed, 11 March 2009 03:27 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Why NOT.

You can upgrade to 10g. But some function/data type obsolete in 10g. (Oracle Forms Item Type : OLTP )

As per 10g Environment you can change your code and then compile.
Re: Oracle DB migration [message #393178 is a reply to message #391001] Fri, 20 March 2009 11:44 Go to previous message
ahudspith
Messages: 26
Registered: January 2009
Location: Avoiding the tax man.
Junior Member

Since this is a new system that you are developing - why the heck are you considering 9i?

You should be using 11g - and as a DBA you should very firmly assert your opinion that this is the version you will deploy.

If you dont do this you are leaving yourself exposed to the problems of migration when you eventually do have to do it.

You also license Oracle by platform/edition... so there is no cost element in using 9i or 11g (in fact 11g is cheaper as you would not need to buy an extended support license)


Adam
Previous Topic: oracle case sensitive
Next Topic: Undo Tablespace not regaining space
Goto Forum:
  


Current Time: Fri Dec 27 21:08:35 CST 2024