Re: double-quoting table names in TOAD - restart - sorry!

On Sep 15, 12:31 pm, ken quirici <ken.quir..._at_excite.com> wrote:
> Hi,
>
> I seem to have deleted my original post - twice! So
> I'm going to start over - as before, database entity
> names are fictitious.
>
> I was in TOAD logged in to schema1 (Oracle 9i).
> I issued the following select statement from the
> TOAD editor:
>
> select count(*) from schema2.table_a;
>
> I got an 'invalid or missing table' message.
>
> After checking the online docs for Oracle 9i,
> I asked a neighboring dba - he entered and
> ran
>
> select count(*) from schema2."table_a"
>
> and it ran successfully.
>
> Why does the table-name in schema2 need
> to be double-quoted when referenced from
> schema1?
>
> Since the dba's query was successful, clearly
> schema1 had access to table_a in schema2.
> (I had been told this before I ran the query anyway).
>
> Thanks for all your replies up til now, and
> your corrections.
>
> However I don't believe anyone has answered my
> question yet.
>
> Thanks again for your help.
>
> Ken Quirici

Use http://tahiti.oracle.com in the future to answer such simple questions.

http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements9a.htm#27566 Received on Sat Sep 15 2007 - 12:48:34 CDT