Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Finding the DB State

Re: Finding the DB State

From: Michael Pelzelmeyer <michael.pelzelmeyer_at_herba-chemosan.at>
Date: 1998/03/11
Message-ID: <3506DA1A.38EA@herba-chemosan.at>#1/1 







krish wrote:


> 

>     Hi ,

> 

>             Is there any v$ table/view that tells me the state of the

> database - whether opened / closed / mounted ??

Check out v$thread (column status), but it seems not to work in all
cases correctly (NT/7.3.3)


  startup mount -> 'OPEN'             ???
  alter database open -> 'OPEN'


  alter database close -> 'CLOSE'


HTH



Michael
Received on Wed Mar 11 1998 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US