We have a production oltp that has logs build on tables necessary to reporting so that we and replicate them to the reporting database. I am trying to set up a valid test environment with exp/imp. I need to use exp with consistent=y so we don't have referential problems. So far, I have been unable to avoid:
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 1033
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 942:
on import. I've thought maybe triggers=n or something. Anyone have any ideas?
18.104.22.168/ HP-UX 11