Re: Dabatabase problem !!!! URGENT !!!!

Since you do not care about the lost files, re-create the entire database. First make sure that there are no files remaining like redo and control and then write a create database script to start all over.

If you had a full export file you could recreate the missing tablespaces using it. If the system tablespace still exists you could use the alter database command to remove all missing files and open what is left. You could then drop and re-create the tablespaces.

Either way good luck.

Diego Pafumi <dpafumi_at_us.oracle.com> wrote in article <3652FEA4.3AE654D4_at_us.oracle.com>...
> hi gurus !!!
> I have a big question. I'm new here and someone delete all the *.dbf and
> we don't have a backup. So what I want to do, is to re-install our
> application. I don't care about the previous data there. So .... how can
> I do to run my create tablespace commands????
> because I'm trying to do under the svrmgrl, but I received a message as
> "database not open" (previous I did a startup, but I received a ORA-1110
> datafile not found).
> So I don't know how to continue ????
>
> Thanks a lot !!!
>
> Diego
>
>
Received on Thu Nov 19 1998 - 00:00:00 CET