Re: Default schema...
From: Alvin W. Law <alaw_at_oracle.com>
Date: Thu, 18 Mar 1993 06:24:13 GMT
Message-ID: <ALAW.93Mar17222413_at_ap221sun.oracle.com>
Date: Thu, 18 Mar 1993 06:24:13 GMT
Message-ID: <ALAW.93Mar17222413_at_ap221sun.oracle.com>
jason_at_lgc.com (Jason Pritchard) writes:
>When issuing a select statement the manual says
>SELECT ... FROM [schema.]table ...
>where schema is optional. The manual says that "If you omit `schema', ORACLE assumes
>the table, view, or snapshot is in your own schema."
>Does anyone know of a way to set the default schema to a different
>schema (assuming that you have correct privileges, etc.)?
>In other words, I connect as "a" but want to have "b" as the default
>schema.
I know it doesn't answer your question but the easy workaround is to create synonyms <object name> as <schema>.<object name>
-- Alvin W. Law .............................................. Oracle Corporation Senior Software Engineer ...................... 300 Oracle Parkway, Box 659306 Manufacturing Applications .......................... Redwood Shores, CA 94065 Email: alaw_at_oracle.com ...... Voice: +1 415.506.3390 .... Fax: +1 415.506.7299Received on Thu Mar 18 1993 - 07:24:13 CET