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