Home > Ask the Oracle Database / Applications Experts > Questions & Answers > Impact of Oracle 8i to Oracle 10g migration on scripts
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Impact of Oracle 8i to Oracle 10g migration on scripts

Maria Anderson EXPERT RESPONSE FROM: Maria Anderson

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Oracle tips, scripts, and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 12 April 2007
We are supporting telecom applications. Now we are going to migrate from Oracle 8i to Oracle 10g. We are running Oracle on a Unix environment. Also we are running so many Unix shell scripts and Pro*C scripts. We would like to know, will the migration cause any impact on the Pro*C scripts and Unix scripts? And also please help us with what database impacts migrating from 8i to 10g can cause.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Oracle database installation, upgrades and patches
Oracle's Java database continues push into embedded database market
How to use the Oracle Database Upgrade Assistant (DBUA)
Oracle delivers database fixes in Critical Patch Update
How to get the most out of Toad for Oracle 10
Coca-Cola Bottling swaps out Oracle for DB2
Oracle renews push into embedded open source software market
Oracle releases new database, says 11g upgrade will cut costs
Comparing servers for Oracle database 11g upgrades
Choosing the right server hardware is all about choosing the right software
The best of the Oracle 11g-ready servers

How to upgrade to Oracle 10g
Steps to migrate from Oracle 8.0.6 to Oracle 10g R2
Easiest way to migrate from Oracle 7i to Oracle 10g
How to migrate Oracle 10g to RAC cluster on Linux
Migrate 6 TB of data from Oracle 8.1.7 to Oracle 10gR2
Lessons Learned: Upgrading to Oracle 10g
Database too large for exp/imp migration
How to apply patch to Oracle 10g on Linux?
Migrating 9i database on Windows to 10g on SLES
Impact on memory for upgrade to Oracle 10g
Faster way to migrate to 10g on Linux

Will an upgrade affect my applications or code?
Impact on apps of migration from Oracle 8 to 10g
Impact of upgrade for developer
Will upgrade to 9i impact Oracle Applications?

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
10g  (SearchOracle.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


Migrating from Oracle 8i to Oracle 10g is a big step. I do not have information about your environment, what the scripts do, etc., but I would expect that there will be some impact to your scripts with this migration. To mitigate this risk, I would hope that part of your migration plan is to test this process thoroughly in a non-production environment prior to migrating the database. Only by testing your scripts will you know with certainty what the impact of this migration will be and what needs to be done to ensure that the scripts function properly when the migration occurs in production.

The Oracle 10g Release 2 (10.2) Pro*C/C++ Programmer's Guide has a section titled "What's New in Pro*C/C++?" This might help identify scripts where you may encounter issues after the migration. As well, the Oracle Database 10g Release 2 (10.2) New Features Guide may also be helpful.

Finally, the Oracle Database 10g Release 2 (10.2) Upgrade Guide specifically addresses the different areas of testing that are crucial to a database upgrade.




Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts