Default schema name

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 Wed Jul 12 2000 - 00:00:00 CDT