Originally posted by oddster
Does anyone know about the process of snapshot registration during an import "Create snapshot" statement?
I have encountered problems with snapshot replication between Solaris and HP-UX. However, your strategy is not the best possible. There is no need to import MVs. You better just recreate them. I would be curious to see all the information from "SELECT * FROM DBA_JOBS where JOB=" for the MV in question. Did you try to manually restart the refresh with "EXEC DBMS_SNAPSHOT.REFRESH('TVP219UNITMEASURE');"?