Re: Change default schema

I am developing number of lexical databases, for at least three different languages. The table definitions are identical, but I wanted to distinguish between the databases by creating them in different schemas.

That part is OK, but I am using Oracle Forms to access the data. It is not possible (I think) in Forms to alter the name of the base table.

I would like the end user to be able to use the same Forms application to access all three databases, but to select at startup which language to work with. It is possible to create private synonyms in the users schema, but this will prevent the user from starting two sessions at the same time, accessing different language databases. It will also be a problem if the user for some reason creates an object in his/hers schema with the same name as an object in the lexical databases.

Lars Jørgen

Robert wrote:
>
> Why not just select from all_objects where onwer = schema_name .....
> Lars Jørgen Tvedt <ljt_at_dokpro.uio.no> wrote:
>
> >Is there a way to alter the default schema/namespace in a
> >user session? I want Oracle to default search for an object in
> >another users schema, and not in the schema of the current user.
>

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Lars Jørgen Tvedt, Dokumentasjonsprosjektet, Universitetet i Oslo Postboks 1123 Blindern, N-0317 OSLO
Telefon (+47) 22 85 49 84, Fax (+47) 22 85 49 83 Received on Thu Oct 16 1997 - 00:00:00 CDT