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 -- //www.freelists.org/webpage/oracle-l