With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by userprod, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing userprod's objects into userdeliv. . importing table "table_name"
IMP-00058: ORACLE error 12008 encountered
ORA-12008: error in materialized view refresh path
ORA-00001: unique constraint (userdeliv.SYS_C0091970) violated
IMP-00028: partial import of previous table rolled back: 24224702 rows rolled back
"BEGIN SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('userprod,'table_name'); "
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
ORA-06512: at "SYS.DBMS_ISNAPSHOT", line 108
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 1666
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully
I have a materialized view log on a table.
I imported rows of that table in a development schema and I don't understand with oracle doesn't try to refresh the log of userdeliv and instead it tryes to refresh the log of produser: "BEGIN SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('userprod,'table_name'); "
and I can't find anything about DBMS_SNAPSHOT_UTL.SYNC_UP_LOG on oracle documentation.