Re: Cannot delete Tablespace without datafile

Yes, I did. I tried that option out.

Is there a way fix the header information in a database file? This question I ask as it I performed one operation as follows:

I tried to copy a datafile from another tablespace. But somehow, Oracle knows that I copied the datafile # and wouldn't let me open the database.

The media recovery option did not work as I did not have the database running in the ArchiveLog mode.

Getting pretty tough here. Thanks for your response though.

-Sudarshan

Syltrem wrote:

> Have you tried RECOVER UNTIL CANCEL ?
>
> I'm not sure but it may work
>
> Syltrem
>
> Sudarshan Sampath <ssampath_at_home.com> wrote in message
> news:393668CE.C0FE7CE9_at_home.com...
> > Is there a way to drop a Tablespace that has no datafile?
> > I accidently deleted the datafile associated with the
> > tablespace and I have no back up for it.
> >
> > I performed the following steps to fix the problem after shutting down
> > the
> > database and mounting it in exclusive mode:
> > > alter database create datafile 'raid/oracle/app/abcd.dbf'
 Media recovery is needed after this step
> > > alter database recover datafile 'raid/oracle/app/abcd.dbf'
> > Now, it complains that with this error:
> >
> > ORA-00279: Change generated at 5/31/00 12:50pm needed for thread 1
> > ORA-00289: Suggestion : '/raid/oracle/app/000014244.arc'
> > ORA-00280: Change 1234567865 for thread 1 is in sequence #86831
> >
> > After this step, the database doesn't open at all. It complains bad
> > header
> > file.
> >
> > Is there a simple way to delete the datafile or tablespace when database
> >
> > is mounted only?
> >
> > Please advise.
> >
> > -Sudarshan
> >
Received on Thu Jun 01 2000 - 00:00:00 CDT