Re: Starting oracle whit some tablespace

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 29 Oct 1998 14:04:55 +0200
Message-ID: <719lpb$14e$1@hermes.is.co.za>

DP wrote in message <719l87$8o0$1_at_news.flashnet.it>...
>I have a problem.
>I have corrupted a datafile!!!
>I want to start the database but the sqldba
>gives me the ora-01110 and ora-01115 error.
>how can i do to start the database remove the
>datafile???

"ALTER DATABASE DATAFILE 'filename' OFFLINE DROP" is the statement I think.

But then ONLY use it when you are SURE that's the only way to correct/recover the database.

regards,
Billy
--
usual disclaimers apply :-) Received on Thu Oct 29 1998 - 06:04:55 CST