Problem with export and mat view logs...

  • From: Chris Stephens <ChrisStephens@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 2 Mar 2004 07:59:15 -0600

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:

 "BEGIN
SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('NET_#####_PROD','CRM_CASE_LOG');"

 " END;"

 

 

on import.  I've thought maybe triggers=n or something.  Anyone have any
ideas?

 

8.1.7.2/ HP-UX 11

 

 

Thanks

chris

 

 

 

Other related posts:

  • » Problem with export and mat view logs...