Home » RDBMS Server » Server Utilities » Upgradation 9i R2 to 10g R2 (Orcale ,10g , RHEL 3.0)
Upgradation 9i R2 to 10g R2 [message #314615] Thu, 17 April 2008 05:25 Go to next message
biswas_tt
Messages: 6
Registered: April 2008
Junior Member

I am upgrating my DB from 9i R2 to 10g R2 . I have started my 9i DB in 10g home with 'startup upgrade'. Now i need to run one sql file which should be present in $ORACLE_HOME/rdbms/admin directory u0902000.sql but i am not finding this sql file in said directory.

Could u pls help where should i get this file? Should i copy seperately , in that case where should i get this file?

Thanks in Advance.

Tarun

Report message to a moderator

Re: Upgradation 9i R2 to 10g R2 [message #314679 is a reply to message #314615] Thu, 17 April 2008 08:22 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You should run catupgrd.sql.

Check Upgrading to the New Oracle Database 10g Release.

Report message to a moderator

Re: Upgradation 9i R2 to 10g R2 [message #314689 is a reply to message #314679] Thu, 17 April 2008 08:45 Go to previous message
biswas_tt
Messages: 6
Registered: April 2008
Junior Member
Thank you very much.

Report message to a moderator

Previous Topic: EXDP ERROR
Next Topic: IMP-00051: Direct path exported dump file contains illegal column length
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 03:10:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.