Re: How to close database using alter database close?
From: Tony Hunt <tonster_at_bigpond.net.au>
Date: Mon, 17 Sep 2001 13:11:15 GMT
Message-ID: <TDmp7.61779$bY5.299814_at_news-server.bigpond.net.au>
Date: Mon, 17 Sep 2001 13:11:15 GMT
Message-ID: <TDmp7.61779$bY5.299814_at_news-server.bigpond.net.au>
You need to identify the current sessions the the V$SESSIONS system table and disconnect them first.
"Unknown User" <unknown_at_unknown.com> wrote in message
news:3bhvpt4diouitjtvi1ejqvn5fr3prsbnbn_at_4ax.com...
> Hi,
>
> I am using Personal Oralce 8i 8.1.7 on Windows 2000 SP2.
>
> I just want to close the database without shutting down to rename some
datafiles
> and am getting this error message. How do I close the database? Thanks.
>
> SQL> alter database close;
> alter database close
> *
> ERROR at line 1:
> ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
>
Received on Mon Sep 17 2001 - 15:11:15 CEST