Problem with export and mat view logs...

From: Chris Stephens <ChrisStephens_at_affina.com>
Date: Tue, 2 Mar 2004 07:59:15 -0600
Message-ID: <4A82CFCF30FDD211A7960008C7B191702369689B@hero.affina.net>

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      

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Mar 02 2004 - 07:57:47 CST