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) ?
Why not create synonyms for these objects on the source database, so the synonyms will be imported before procedures, and the procedures will be valid.
You have the seem objects on multiple schemas?
Click Here to Expand Forum to Full Width