Re: Default schema name

The command is:

Alter session set current_schema = schemaname

(You will have to have been granted privileges to that schema to access it's objects)

Jaco Grobler wrote:

> 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 Sep 14 2000 - 21:29:06 CDT