RE: Offline status in dictionary

From: Randy Johnson <randyjo_at_sbcglobal.net>
Date: Sat, 14 Jul 2007 20:03:45 -0500
Message-ID: <006a01c7c67b$fef20760$6701a8c0@scraunch>

If it was missing when the database started up then that would cause the datafile to be offline. I would imagine that would include cases where the database could not write to the datafile. I know this is true in 10g not sure about 9i. In 7 and I believe 8 & 8i the database would simply not open but that behavior has changed in 10.

-Randy

Randy Johnson
Sr. Technical Consultant
Enkitec, LLP

Office ..... 817-255-3580
Mobile .... 817-564-6583
Email ..... HYPERLINK

"mailto:randy.johnson_at_enkitec.com"randy.johnson_at_enkitec.com

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ankur Godambe
Sent: Friday, July 13, 2007 3:16 PM
To: oracle-l_at_freelists.org
Subject: Offline status in dictionary

Hi,

Apart from explicitly putting datafile or tabespace in offline mode though alter database….. or alter tablespace….. command , under what circumstances would STATUS column in v$datafile and dba_tablespaces change to OFFLINE?

Thanks.

No virus found in this incoming message. Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.5/899 - Release Date: 7/13/2007 3:41 PM

No virus found in this outgoing message. Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.5/899 - Release Date: 7/13/2007 3:41 PM

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jul 14 2007 - 20:03:45 CDT