Re: someone deleted my datafile

From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Mon, 22 Dec 2008 13:04:54 -0500
Message-ID: <74f79c6b0812221004p72c6029ek89b66c3b89b8d3ea@mail.gmail.com>

Perhaps tablespaces requires some data dictionary updates which would require the database to be open. Datafiles only require the controlfile to be open, which is done when the database is mounted.

Finn

On Fri, Dec 19, 2008 at 12:50 PM, Dba DBA <oracledbaquestions_at_gmail.com>wrote:

> what is the rationale behind not being able to take a tablespace offline
> when the database is not open, but being able to take a datafile offline?
> that one tricked me up for a little while. Any idea why oracle made it that
> way?
>

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

Received on Mon Dec 22 2008 - 12:04:54 CST

This message: [ Message body ]
Next message: Ethan Post: "10G UTL_FILE ORA-29283 DBMS_JOB"
Previous message: Maureen English: "Re: Running utlrp creates too many Pnnn processes"
In reply to: Dba DBA: "Re: someone deleted my datafile"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message