Refering to tables outside your schema - HELP!!!
From: TAMDY <tamdy_at_aol.com>
Date: 1995/06/25
Message-ID: <3sjmbl$867_at_newsbf02.news.aol.com>#1/1
If we make the table PUBLIC, the program runs successfully. However,
it
is not our desire to make the table PUBLIC.
Date: 1995/06/25
Message-ID: <3sjmbl$867_at_newsbf02.news.aol.com>#1/1
We are trying to refer to a table that exists in a different schema,
without
prefixing it by the schema name. These are the steps we are taking.
refers to this table by its synonym, she gets the error
ORA-00942 Table or view not found
What's wrong with this approach?
Received on Sun Jun 25 1995 - 00:00:00 CEST