Re: alter database recover managed standby database disconnect from session;

From: Jörg Jost <jost_at_unitrade.com>
Date: Wed, 20 Sep 2006 11:53:37 +0200
Message-Id: <1158746017.6630.8.camel@localhost>

On Tue, 2006-09-19 at 14:09 -0500, Roger Xu wrote:
> Hi List,

>[...]

> SQL> alter database recover managed standby database disconnect from
> session;
>
> Database altered.
>
> SQL>
>
> Why the prompt returns? I thought "disconnect from session" will kill
> the session?
>
> Thanks,
>
> Roger

Hi Roger,

as far as i remember, is the clause "disconnect from session" just for the case, that one is able to end the OS-Session without kicking the statement.

If you omit this clause, you are not able to quit the SQLPLUS-Session without quitting the recover - Session.

hth

Jörg

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 20 2006 - 04:53:37 CDT