SV: Re[2]: sgadefbaanIV.dbf

From: Leif Andersson <leif.andersson_at_sub.su.se>
Date: Fri, 09 Feb 2001 09:44:03 -0800
Message-ID: <F001.002B08CF.20010209093518@fatcity.com>

In spite of its file extension the content of my sgadef<SID>.dbf (Oracle 8.0.5.0.0 Enterprise on Solaris) is pure text.

It says:
"This file is now obsolete. It will be removed in a future release. To determine whether an instance is up, you should check for the existence of the PMON process associated with the instance."

Leif Andersson, Systems Librarian
Stockholm University Library
Sweden

-----Ursprungligt meddelande-----

Från: Mohammad Rafiq
Till: Multiple recipients of list ORACLE-L Skickat: 2001-02-09 17:32
Ämne: Re: Re[2]: sgadefbaanIV.dbf

shutdown abort also removes in case your database crash ,connect internal
and shutdown abort will remove it or alternately deletion is the only option. If it remains there, database will not start. Regards
Rafiq

To: "Mohammad Rafiq" <rafiq9857_at_hotmail.com>, Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Fri, 9 Feb 2001 11:22:10 -0500

One other point, If you manually delete this file the DB will crash. To

some
good degree it totally disappears in 8i.

Dick Goulet

____________________Reply Separator____________________
Author: "Mohammad Rafiq" <rafiq9857_at_hotmail.com>
Date:       2/9/2001 7:35 AM

No removal is required. It is generated as a result of your database and goes away when you shutdown database. Oracle uses this file in it dbstart
script to check
whether database is up or not.

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Fri, 09 Feb 2001 06:31:11 -0800

Hi Gurus

I don't know How this file generated by database, What is significance of
this file?? Can I delete this file??? Is there any use ???

Thanks in advance
Raghu.

---

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Raghu Kota

   INET: raghukota_at_hotmail.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).

---

Get your FREE download of MSN Explorer at http://explorer.msn.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mohammad Rafiq

   INET: rafiq9857_at_hotmail.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).

---

Get your FREE download of MSN Explorer at http://explorer.msn.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Leif Andersson
  INET: leif.andersson_at_sub.su.se

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). Received on Fri Feb 09 2001 - 11:44:03 CST