Re: HELP: missing dbf file

You will have to do an
alter database datafile offline drop
but please note all of the data on lost datafile is gone since you do not have a backup, AND the datafile still exists in the data dictionary. So what you want to do now is extract the ddl for all invalid objects and move all valid objects to another tablespace. I would then drop the tablespace, then recreate the tablespace and all of the invalid objects. Also watch out, doing an offline drop is just so that you can open the db, the database may still try to write to that datafile. glen

henry valdes wrote:
>
> I inadvertently deleted a *.dbf file. The instance will start and I
> can mount the DB but can not open it.
>
> Rec'd the error message: "ORA-01157 cannot identify data file name -
> file not found" when I try to open the DB.
>
> A solution from the Oracle message and code manual simply says to
> "make the file available to the database".
>
> How can this be accomplished and/or can I develop a temporary
> work-around so that the users can gain access. Can I re-create this
> file and/or disassociate it?
>
> Note: I do not have a back-up copy.
>
> Thanks in advance.

Received on Thu Apr 08 1999 - 17:21:06 CDT