Tony Foiani wrote:
> >>>>> "Tim" == Tim Bunce <[EMAIL PROTECTED]> writes:
>
> Tim> I think in very recent Oracle's there's an SQL command (probably
> Tim> 'SET ...') that lets you switch default schema.
>
> Is this what you are thinking of?
>
> ALTER SESSION SET CURRENT_SCHEMA = ....
>
> We use "ALTER SESSION" extensively in our project here, primarily to
> set the NLS_DATE_FORMAT to be something sane. It's described in the
> _Oracle8i SQL Reference_ (Release 2, 8.1.6, A76989-01), Chapter 7
> ("SQL Statements").
Thanks a lot: this works for me!
And yes, as Mark stated: I had to fizzle around with privileges,
but now everything works fine.
Joern
--
Joern Reder -- Software Development, dimedis GmbH, Koeln
Besuchen Sie uns vom 22.-28.03.01 auf der CeBIT, Halle 1, Stand 4c4
http://www.dimedis.de/terminvereinbarung