Home » RDBMS Server » Server Administration » Migrating from Oracle 8 to 10
Migrating from Oracle 8 to 10 [message #111898] Mon, 21 March 2005 11:54 Go to next message
smagnotta
Messages: 7
Registered: February 2005
Junior Member
Hi,

Hopefully this is the right section to ask this question. Anyone: our company uses Oracle 8i (release 3 - 2000) for its database server. We want to go to version 10. We use the basic SQL and PL/SQL commands any database uses. Is version 10 backward compatible with version 8, or are there major differences or things that have been deprecated/obsoleted?

I know that server manager no longer exists (svrmgrl.exe), as SQL Plus does many of the commands anyway.

Should we just go to version 9 instead? We are on a Windows platform as far as development (2000 server and XP). Version 8 doesn't have XP support.

We have a Java client server application (Apache Webserver, Tomcat servlet container, Java servlets and applets, Xerces XML Parser, HTTPS and SSL).

Thanks,
Sal Magnotta

Report message to a moderator

Re: Migrating from Oracle 8 to 10 [message #111899 is a reply to message #111898] Mon, 21 March 2005 12:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
There are many new features for developers and administrators.
If you are not using complex oracle features, just an export and import should help.
10g should be doing good for you.
just becuase there are too many new thingies, to be in the safer side, I would set up a parallel 10g environment, load the data from oracle 8 and test the application and get used to the new features available.

>>hould we just go to version 9 instead? We are on a Windows platform as far as development (2000 server and XP). Version 8 doesn't have XP support.

All versions / releases of oracle 8 are desupported long back.
9i will very soon join the list.
So it just better to go for 10g.

Report message to a moderator

Re: Migrating from Oracle 8 to 10 [message #111931 is a reply to message #111898] Mon, 21 March 2005 22:31 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I agree totally. It is important to test. Create yourself a test system in 10, load your data, and run your app.

I also agree to go to 10 and not 9, for the very reasons mentioned. To me each oracle version gets better and better, and there is no sense to not have the latest features and support.

And it is more than the major new features you hear about. There are little tiny things here and there with each version that are improved with each release, and there have been 3 and about to be a 4th release since 8.1.7.

Features that at one time were new have now had most/all of the kinks worked out and are more stable. And new features make the database better and easier to administer. Not to mention, plsql has undergone some tremendous improvements in 10 that will run your existing code much faster.

I'd start testing on 10gR1 now, with the idea of doing the production upgrade straight to 10gR2 (assuming that upgrade path is supported, and assuming release 2 comes out in the next month or two as expected).

Report message to a moderator

Previous Topic: drop table problems
Next Topic: Howto migrate a LOB type INDEX to another tablespace (ORA-02327)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 03:33:42 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.