Importing a Oracle 7 dmp file into 10g

I am importing an oracle 7 dump file into a 10g database. I am not able to know the difference between a snapshot and a materialized view, in a detailed manner. As in Oracle 7 there were snapshots and there are materialized views,now a days.

Can someone tell from his experience whats the best way to deal with this situation ? Will the import just work fine or there would be some issues with creation of snapshots ? Any tips and tricks to go with minimum possible number of errors.

Also there are comments on snapshots in the old database. I just checked that we cannot create comments on materialized views in 10g using "comment on table x is y". Instead we have to use "comment on materialized view x is y" and also it goes into all_mviews_comments instead of all_tab_comments. [Actually there is some front end in the application that uses data from all_tab_comments to display information about the snapshots] So for this I guess I will need to take some manual action. Extracting the comments from log created using show=Y and then manually adding to materialized views.

Any tips are welcome :)

Thanks in Advance
Sidhu Received on Fri Sep 14 2007 - 06:23:22 CDT