I have an environment in Oracle 9i Release 2, containing Materialized Views and Materialized View Group.
I took the export of the entire database. and import it again.
The problem that i facing here is .. all the materialized Views are imported successfully... but no the Materialzied View Group.
How m i going to imprt the Materialized View Group. ???
08-15-2003, 03:19 AM
You should have the groups.
Check your import log file for errors.
Do the jobs exist to refresh your groups?
08-16-2003, 02:21 AM
I checked out the imp log file . It havent got any information regardinh the materialized view groups. Beside that the dba_repGroup and dba_repsites have no record now, imean after importint the entire database or importing a pareticular user.