Import (User mode) with snapshot view?!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import (User mode) with snapshot view?!

  1. #1
    Join Date
    Feb 2001
    Posts
    22

    Angry

    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) ?


  2. #2
    Join Date
    Feb 2001
    Posts
    66
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width