double-quoting table-names in across-schema access

From: ken quirici <ken.quirici_at_excite.com>
Date: Sat, 15 Sep 2007 07:03:11 -0700
Message-ID: <1189864991.298383.218190@19g2000hsx.googlegroups.com>

Hi,

I was in schema1 (not the actual name) in TOAD -Oracle 9i - and tried

select count(*) from schema2.table1; (not the actual names)

I got an 'invalid or unknown table' error, although, as you will see below, schema1 has read access to schema2.

After various attempts at figuring this out, including running down refs to " in the Master Index for the Oracle 9i documentation set, I asked one of the dbas for help. He typed this into my session and it worked:

select count(*) from schema2."table1";

Anybody have any idea what principle is involved here? As I said it's not documented. Is it a TOAD issue, or maybe an issue accessing Oracle from a fat client like TOAD? Maybe the same 'fix' would also be needed from a C or C++ client? But that would have turned up a reference in the Master Index.

Whatever the principle, it's got to be documented somewhere!

Any help appreciated.

Thanks.

Ken Quirici Received on Sat Sep 15 2007 - 09:03:11 CDT