Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!proxad.net!216.239.36.134.MISMATCH!postnews.google.com!u72g2000cwu.googlegroups.com!not-for-mail
From: "Mike" <mrmichaellei@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Question about materialized view when upgrade 9i to 10g
Date: 4 Apr 2006 08:21:34 -0700
Organization: http://groups.google.com
Lines: 15
Message-ID: <1144164094.232181.95720@u72g2000cwu.googlegroups.com>
NNTP-Posting-Host: 199.245.220.253
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1144164100 6665 127.0.0.1 (4 Apr 2006 15:21:40 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 4 Apr 2006 15:21:40 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: u72g2000cwu.googlegroups.com; posting-host=199.245.220.253;
   posting-account=knvFaQ0AAADOEH03LgP16OI24UsKw3M9
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:264811

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