if so just drop all the rupd$ and mlog$ tables (and recreate the materialized view logs if desired) i ran in to this problem when i was refreshing our development environment and was baffled for quite some time. for a few days, my solution was to drop and recreate the table. after posting the problem to this list, mladen so kindly helped me offline in troubleshooting the problem (thanks mladen). i think the trace command took the form of: ALTER SESSION SET EVENTS=3D'(error # here) trace name errorstack forever,level 10' anyways, i hope this is your problem because it is easily remedied. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Chris Stephens Sent: Tuesday, August 24, 2004 7:16 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: database problem migrating from 9i to 10g on Solaris are there by chance materialized view logs on these tables? did you by chance migrate via import/export? -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ian Dickens Sent: Tuesday, August 24, 2004 5:20 AM To: oracle-l@xxxxxxxxxxxxx Subject: Q: database problem migrating from 9i to 10g on Solaris <preface - this is pre-coffee> I've been fighting an issue which has me baffled. Basically, i=3D20 performed a database upgrade of Oracle on Solaris 8 migrating 3=3D20 instances from 9i to 10g. Everything seemed to progress well. Labels=3D20 are not installed. User/password data and schema are are there=3D20 (according to the console). Users can create, populate and select from=3D20 new tables created post upgrade - however, they cannot see tables=3D20 brought from 9i. SYSDBA cannot see tables brought from 9i. The tables are there in the EM console, they have 55000 or so records. =3D20 I've messed with grants, roles and system privs - I'm at a loss. I=3D20 still have the 9i data though the databases in 9i are shutdown. = Has=3D20 anyone encountered this problem? I should mention the error is=3D20 ORA-00942. History: 9i -> 10g (10.1.0.2) yesterday, I added patch 10.1.0.3 seeing the ORA-00942 issue - = fixed=3D20 nothing. Many thanks in advance, Ian Dickens ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------