Migration from 9i to 10g.
Serguei.G...@cibc.ca
Our organization is moving from Oracle 9i to 10g. I know about some
technical issues during migration of the database itself, but what
about the user application level (SQL/PL scripts, triggers, sequences,
indexes and so on)? Is there something Experts could recommend to do
or to avoid? Are there any user related problems in the 10g
environment?
Regards,
Serguei.
DA Morgan
Strip all 9i hints from all code.
Dump all cursor loops and replace with array processing using BULK
COLLECT and FORALL.
Turn on warnings before compiling any code and follow up on all
warning messages. To do this look at this page:
http://www.psoug.org/reference/dbms_warning.html
The demos will show you how it works.
Note: 11g contains new warnings not present in 10g so some demos will
not work in 10g. PLW-06002 is one that works in both 10g and 11g.
--
Daniel A. Morgan
University of Washington
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Jan Krueger
> Serguei.G...@cibc.ca wrote:
>> Dear Experts,
>> Our organization is moving from Oracle 9i to 10g. I know about some
>> technical issues during migration of the database itself, but what
>> about the user application level (SQL/PL scripts, triggers, sequences,
>> indexes and so on)? Is there something Experts could recommend to do
>> or to avoid? Are there any user related problems in the 10g
>> environment?
>> Regards,
>> Serguei.
>
> Strip all 9i hints from all code.
>
> Dump all cursor loops and replace with array processing using BULK
> COLLECT and FORALL.
performance issue in 9i there is no need to do it in 10g.
> Turn on warnings before compiling any code and follow up on all
> warning messages. To do this look at this page:
> http://www.psoug.org/reference/dbms_warning.html
> The demos will show you how it works.
Interesting idea.
Also I would recommend to perform a test upgrade with a duplicated
environment and perform a full regression test.
Jan