Members   Search   Help    Register    Login   Home
Home » RDBMS Server » Server Administration » 9i to 10g upgrade - Materialized views
9i to 10g upgrade - Materialized views [message #429909] Fri, 06 November 2009 04:29 Go to next message
prashanthgs
Messages: 49
Registered: May 2005
Location: chennai
Member
Hi,

We are planning to upgrade the db from 9i (9.2.0.4) to 10g (10.0.2.0).

As we are moving from 32 bit to 64 bit we are doing upgrade by exp/imp method. Db size is less.

There are lots of Materialized views on source database. Could you please suggest what would be the best approach to move these materialized views after upgrade.

OS: Sun solaris
Oracle 9i/10g

Thanks in advance.

Prashanth
Report message to a moderator
Re: 9i to 10g upgrade - Materialized views [message #429912 is a reply to message #429909] Fri, 06 November 2009 04:55 Go to previous messageGo to next message
Michel Cadot
Messages: 29416
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
As database is small, recreate them.

Regards
Michel
Report message to a moderator
Re: 9i to 10g upgrade - Materialized views [message #429926 is a reply to message #429909] Fri, 06 November 2009 05:50 Go to previous message
JRowbottom
Messages: 5362
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Why are you not migrating to the latest release - 10.2.0.4?
Report message to a moderator
Previous Topic:Want to change sys password
Next Topic:Restoring statistics in oracle10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 30 10:02:27 CST 2009

Total time taken to generate the page: 0.30665 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.