Question about materialized view when upgrade 9i to 10g

From: Mike <mrmichaellei_at_yahoo.com>
Date: 4 Apr 2006 08:21:34 -0700
Message-ID: <1144164094.232181.95720@u72g2000cwu.googlegroups.com>

Hi,

I am planning to upgrade our major datawarehouse database from 9.2.0.4 to 10g release 2. The database has many snapshots to pull data from other production oltp databases. They are either group together as a refresh group or as a part of a dbms job. I was wondering after upgrade, do I have to re-create them (snapshots, dbms_jobs) all ? is there a script to capture all ddl? Is dbms_metadata working also with dbms_jobs ?

Thanks.

Mike Received on Tue Apr 04 2006 - 10:21:34 CDT