Re: problem with missing tablespaces

From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: Mon, 21 Jun 1999 14:25:04 -0400
Message-ID: <376E8380.E96C598C@lucent.com>

First of all, why did you remove the data file? The only time you should delete the OS file is if you drop the tablespace.

Try this:
svrmgrl
>connect internal;
>shutdown abort;
>startup force;

You will get some error messages but at least it should start your instance.

What would be even better if you can get that data file back using a backup. You do take system level backups don't you?

Ken

Pietro Abate wrote:

> HI,
> I have removed a dbs file and now I can't connect and use my
> default db... this dbs file belongs to a tablespace named 'prova'.
>
> how could I drop or alter this tablespace ?
> how could I change my default DB ?
>
>
Received on Mon Jun 21 1999 - 13:25:04 CDT