Hi there,

I exported a oracle dump with export in user mode. The schema contains snapshot view.

In my development database, I used

imp fromuser=a touser=b file=expdat.dmp to import the dump into my development database.

Everything is fine. However, following error will be generated at the end of import.

IMP-00017: following statement failed with ORACLE error 942:
"BEGIN SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('A','SHPSHOPITEM'); END;"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 1009
ORA-06512: at line 1

It seem that import will not convert those PL/SQL or DBMS_PACKAGE Username.

The DBMS_SNAPSHOT_UTL.SYNC_UP_LOG still using old username instead of new username in development database.

Anyone have experience to import data with snapshot view in exp/imp (user mode) ?