Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Strange ORA-00942 error
Two small things you may check:
Are synonyms OK at each site?
Can you generate replication support for the table at the master site?
Van
"Wayne Menzie" <waynem_at_bosmedtechdotcom.nospam> wrote in message
news:Xns931B9070E783F8675309OU812_at_66.134.198.18...
> 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 - 15:30:48 CST