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) ?
Click Here to Expand Forum to Full Width