Oracle 8i to 10g

[Shantha]

Hi,

It has been planned in our project to migrate from oracle 8i to 10g. The installation and server upgradation will be taken care by a seperate team.

We need to deploy the complete set of tables, data and stored procedures in 10g.

Is it possible to take simple export & import the data in 10g or can i get the SQL & PL/SQL features deparcated or new in 10g but not supported in 8i.

Thanks in advance.

Talent is what you possess;
genius is what possesses you

 

[ggriffit]

Have you read the 10g documentation ? have you tested your applications on a 10g test system ? have you checked to see that all your objects are valid and compiled on your 10g test system ?

see also

http://www.lmgtfy.com/?q=oracle+8i+to+10g+upgrade

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[oradba101]

Greetings,

You can export to 10g if the 8i version is 8.1.7.4.

Regards,



William Chadbourne
Programmer/Analyst