• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Good business reasons for upgrading from oracle8i to oracle9i

 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,
can someone tell me the good business reasons to upgrade from oracle8i to oracle9i,
Yes,like all of you i also know that it has performance and management advantage over 8i but i am not able to come out with good business reasons to convinvce my boss as every businessman looks at it as a revenue increase point of view,please help me with some good business reasons to upgrade and also any suggestions and your simplest viwes are acceptable.please also write about any technical stuff you think is right.
Thanx a lot in advance,
VS.
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I guess right now the big main reason is support. It a short period of time Oracle will no longer Support 8i. What this means is that there will no longer be patches created for the database. So if in the future you run into a Bug in 8i that makes it impossible to do your work, you will have to upgrade because oracle will not fix it. You will still be able to use Metalink for other support, until a time when they stop that too.
In 9i there are some great enhancements to SQL like the MERGE statement, actual Ansi Joins using "INNER JOIN", "FULL OUTER JOIN" in the FROM clause. If you want to do a full outer join in 8i, you will need a left outer join on both sides and use a UNION. The CASE statement is also a well needed enhancement.
Those are just two. Support being the most important. Unfortunately when you buy Oracle you have to keep giving them money.
Mark
 
vijaya sharma
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanx mark,
This is a good reason,i will be gald if i get more views and responses further.
Again thanx to all you great people out there,
VS
 
reply
    Bookmark Topic Watch Topic
  • New Topic