I think that the correct answer to this question is that in the nomount
stage the database hasn't touched any files yet. So the V$ view, which is
supposed to show the current situation is correct with 0 rows, nothing is
open yet.
----- Original Message -----
From: "Philip West" <P.West_at_g-icap.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, August 25, 2000 5:01 AM
Subject: RE: v$controlfile in nomount
> Interesting. I have not considered this before. I would assume the
reason
> is that the controlfile is database specific and in the nomount stage you
> have an instance up and no database mounted.
>
> Phil West - Impex IT ltd
> Unix Sys Admin and Oracle Financials DBA Services
>
> all opinions are worth [at most] what you paid for them
>
>
>
> -----Original Message-----
> Sent: 25 August 2000 05:06
> To: Multiple recipients of list ORACLE-L
>
>
> Hi all,
>
> I was just checking the availability of v$ views in nomount
> and mount stages. I got stuck with V$CONTROLFILE .
> As the controlfile locations are specified in init.ora
> file , I think it should be available in NOMOUNT stage itself.
> It doesn't give any error and displays ZERO record in
> NOMOUNT stage while in mount stage it displays the correct info.
> Could someone explain please ....
>
> TIA,
> Rajesh
> --
> Author: Rajesh Dayal
> INET: Rajesh_at_ohitelecom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
***
> The information in this Internet e-mail is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
Internet e-mail by anyone else is unauthorised and any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it,
is prohibited and may be unlawful.
> When addressed to our clients any opinions or advice contained in this
Internet e-mail are subject to the terms and conditions expressed in any
applicable documentation or market practices governing the relationship
between Garban Intercapital plc and its clients.
>
> Any views expressed in this message are those of the individual sender
except where they are stated to be the views of Garban Intercapital plc.
>
***
> --
> Author: Philip West
> INET: P.West_at_g-icap.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Sat Aug 26 2000 - 10:27:07 CDT
