I'm getting an ORA-00942 (table or view does not exist) that doesn't
make any sense. I'm able to select * from the table but any DML
fails with the ORA-00942 error. This table is part of a multi master
replication group and the other tables appear to be functioning
properly. There are no invalid objects in the database at either
master site and the repobjects are all valid as well. The same table
at the master definition site does not exhibit this problem. As far
as I can tell, the tables are identical at the two sites, except for
this problem.
This is happening Oracle 8.1.7.4.1 Enterprise Edition on Windows NT
4, SP 6a. I've run catalog.sql, catproc.sql and catrep.sql as SYS
and the situation hasn't changed. The table has no triggers or
foreign keys. Up until now, the system has been performing
flawlessly and there are no configuration changes that I am aware of
that might have caused this. I am perplexed and would appreciate any
help you might have. Thank you.
--
Wayne Menzie
Received on Fri Feb 07 2003 - 13:12:30 CST
