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

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
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: 5933
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: error ORA-01555 in Oracle 10g
Next Topic: Restoring statistics in oracle10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 11:46:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.