Re: Default schema name

In oracle V7, here's an undocumented and possibly unsupported method for doing what you want:

    alter session set current_schema=<schema_name>;

I'm uncertain whether this is still in V8 and/or whether it will be supported or included in the future.

-Kevin Brand
"Jaco Grobler" <jacog_at_pillar.co.za> wrote in message news:396d4e0b$0$779_at_proctor...
> Hi All
>
> I would like to know if there are a way to define a default schema name
> other than the users own schema for a userid. I come from a Sybase
> background where you can create a object in the dbo. schema and if no
 schema
> name are supplied when trying to access the object and the object does not
> exist in the users schema it will go and look for the object in the dbo
> schema
>
> We are busy converting to Oracle but are experiencing problems with trying
> to access objects in a certain schema without specifying the schema name.
> The existing stored procs etc. do not use the schema name and it will be
> quit a lot of work having to place the schema name in front of every
 object.
>
> TIA
> Jaco Grobler
>
>
>
>
Received on Thu Jul 13 2000 - 00:00:00 CDT