Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange ORA-00942 error

Re: Strange ORA-00942 error

From: Van Messner <vmessner_at_bestweb.net>
Date: Fri, 7 Feb 2003 16:45:00 -0500
Message-ID: <v48a9j4djffc4@corp.supernews.com>


Well you have an unusual problem. One way to get a message that something doesn't exist is if you have a synonym pointing somewhere other than where you think, so I often take a look at synonyms when I'm trying to track down a 942.

"Wayne Menzie" <waynem_at_bosmedtechdotcom.nospam> wrote in message news:Xns931BA990C75B68675309OU812_at_66.134.198.18...
> "Van Messner" <vmessner_at_bestweb.net> wrote in
> news:v489epkrmhah8a_at_corp.supernews.com:
>
> > Are synonyms OK at each site?
>
> What synonyms are you talking about? I'm logging in as the owner of
> the table so I don't need to use a synonym.
>
> > Can you generate replication support for the table at the
> > master site?
>
> Unfortunately, I cannot quiesce the replication group right now so
> there is no way to try that at this moment. I should point out that
> at both sites, the table's status in dba_repobject is 'VALID' and so
> is the package and package body used for replication on that table.
>
> --
> Wayne Menzie
Received on Fri Feb 07 2003 - 15:45:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US