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: 89
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
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: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As database is small, recreate them.

Regards
Michel
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: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Why are you not migrating to the latest release - 10.2.0.4?
Previous Topic: error ORA-01555 in Oracle 10g
Next Topic: Restoring statistics in oracle10g
Goto Forum:
  


Current Time: Fri Dec 02 12:23:31 CST 2016

Total time taken to generate the page: 0.10270 seconds