Re: alter session set schema?

From: <vermaat_at_gemini.tfdl.agro.nl>
Date: 1996/05/10
Message-ID: <1996May10.132501.485_at_ns2>#1/1

In article <4mnu39$nlj_at_news.alaska.edu>, sxdjd_at_orca.alaska.edu (David J. DeWolfe) writes:
>Greetings all;
>
>
>Last September at IOUG-A in Phili, a speaker (sorry, I can't recall the session,
>or the speaker's name) mentioned the "alter session set schema" sql statement. The
>speaker wasn't sure which release of Oracle this appered in, so I called Oracle
>support and asked them. They told me that there was no such command in any
>currently available release of oracle. Does anyone out there know anything about
>this option of the alter session command?

The (undocumented) command is ALTER SESSION SET CURRENT SCHEMA .

You get this statement in an error message if you try to perform an user import from an entire export while the to be imported user does not exist in the database.

---

| Peter J.R. Vermaat | Dutch Department of Agriculture | Wageningen |

---

| p.j.r.vermaat_at_tfdl.agro.nl | http://gemini.tfdl.agro.nl:1024/~vermaat/ |

---

|                           Flagellant in Dreamland                            |
********************************************************************************

Received on Fri May 10 1996 - 00:00:00 CEST