On Nov 22, 9:45 am, cdprasad...._at_gmail.com wrote:
> Hi All,
>
> We are upgrading our database from Oracle 9i to 10g.
> Our development environment is Ascential Datastage ETL Tool
>
> Our project has been already developed by some other team and now only
> database upgradation is happening.
>
> Need some clarifications and solutions
> 1) How we can get to know all these objects are properly upgraded
>
> 2) What can be the best testing strategy for testing all these
> database objects like tables, functions, procedures , views, sequences
> etc. If any similar document has been prepared by any of the projects,
> please send to my mail id
>
> 3) Is there anything we need to do change in any of the objects to
> make compatible with 10g. like any functions that has to be replaced
> or datatype mismatching etc .....
>
> 4) The type of testing needs to be done for different database
> objects.
>
> Thanks cdprasad
You asked an indentical question on OTN.
Wouldn't it be faster to read the Migration Manual?
--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Nov 22 2007 - 05:40:40 CST
