Very Computer

by **eric_dewe..** » Fri, 15 Dec 2000 05:25:14

I have an 8i dB with several Tablespaces the were deleted by rm
the .dbf instead of removing the tablespace. It is causing the
Instance not to OPEN...It will MOUNT but not OPEN. How do I get Oracle
to recognize that the tablespace is gone? How do I remove the
tablespace since there is no .dbf associated with it?

Thanks,
Eric

Sent via Deja.com
http://www.deja.com/

by **Niall Litchfiel** » Fri, 15 Dec 2000 20:44:25

From memory so check the syntax.

alter tablespace X offline drop;

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Quote:> I have an 8i dB with several Tablespaces the were deleted by rm
> the .dbf instead of removing the tablespace. It is causing the
> Instance not to OPEN...It will MOUNT but not OPEN. How do I get Oracle
> to recognize that the tablespace is gone? How do I remove the
> tablespace since there is no .dbf associated with it?

> Thanks,
> Eric

> Sent via Deja.com
> http://www.deja.com/

by **David Fitzjarrel** » Sat, 16 Dec 2000 00:20:38

> From memory so check the syntax.

> alter tablespace X offline drop;

> regards

> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK

> > I have an 8i dB with several Tablespaces the were deleted by rm
> > the .dbf instead of removing the tablespace. It is causing the
> > Instance not to OPEN...It will MOUNT but not OPEN. How do I get
Oracle
> > to recognize that the tablespace is gone? How do I remove the
> > tablespace since there is no .dbf associated with it?

> > Thanks,
> > Eric

> > Sent via Deja.com
> > http://www.deja.com/

Mount the database, then issue the following:

drop tablespace ... including contents;

This should drop the "offending" tablespace and allow the instance to
open.

ALTER TABLESPACE can take a tablespace offline but there is no DROP
option. One can take a datafile offline and drop it with ALTER
DATABASE DATAFILE ... OFFLINE DROP.

--
David Fitzjarrell
Oracle Certified DBA

Sent via Deja.com
http://www.deja.com/

by **Niall Litchfiel** » Sat, 16 Dec 2000 18:03:32

that'll teach me to post from memory rather than grabbing the sql reference.
David is of course quite right.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

> > From memory so check the syntax.

> > alter tablespace X offline drop;

> > regards

> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK

> > > I have an 8i dB with several Tablespaces the were deleted by rm
> > > the .dbf instead of removing the tablespace. It is causing the
> > > Instance not to OPEN...It will MOUNT but not OPEN. How do I get
> Oracle
> > > to recognize that the tablespace is gone? How do I remove the
> > > tablespace since there is no .dbf associated with it?

> > > Thanks,
> > > Eric

> > > Sent via Deja.com
> > > http://www.deja.com/

> Mount the database, then issue the following:

> drop tablespace ... including contents;

> This should drop the "offending" tablespace and allow the instance to
> open.

> ALTER TABLESPACE can take a tablespace offline but there is no DROP
> option. One can take a datafile offline and drop it with ALTER
> DATABASE DATAFILE ... OFFLINE DROP.

> --
> David Fitzjarrell
> Oracle Certified DBA

> Sent via Deja.com
> http://www.deja.com/

by **eric_dewe..** » Sun, 17 Dec 2000 13:16:44

It was mounted but say it can not complete this because the INSTANCE is
not OPEN. Any other suggestions or should I just drop the dB and
recreate it. Its really not that important, just wanted to know for
personal reference in case I ever run into that.

Eric

> > From memory so check the syntax.

> > alter tablespace X offline drop;

> > regards

> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK

> > > I have an 8i dB with several Tablespaces the were deleted by rm
> > > the .dbf instead of removing the tablespace. It is causing the
> > > Instance not to OPEN...It will MOUNT but not OPEN. How do I get
> Oracle
> > > to recognize that the tablespace is gone? How do I remove the
> > > tablespace since there is no .dbf associated with it?

> > > Thanks,
> > > Eric

> > > Sent via Deja.com
> > > http://www.deja.com/

> Mount the database, then issue the following:

> drop tablespace ... including contents;

> This should drop the "offending" tablespace and allow the instance to
> open.

> ALTER TABLESPACE can take a tablespace offline but there is no DROP
> option. One can take a datafile offline and drop it with ALTER
> DATABASE DATAFILE ... OFFLINE DROP.

> --
> David Fitzjarrell
> Oracle Certified DBA

> Sent via Deja.com
> http://www.deja.com/

Sent via Deja.com
http://www.deja.com/

by **Jeremy Russe** » Wed, 03 Jan 2001 09:33:13

Use 'STARTUP MOUNT', then take the tablespaces with missing DBF's
offline. After that, you ought to be able to 'ALTER DATABASE OPEN'
and then drop the tablespaces completely.

Jeremy Russell

>I have an 8i dB with several Tablespaces the were deleted by rm
>the .dbf instead of removing the tablespace. It is causing the
>Instance not to OPEN...It will MOUNT but not OPEN. How do I get Oracle
>to recognize that the tablespace is gone? How do I remove the
>tablespace since there is no .dbf associated with it?

>Thanks,
>Eric

>Sent via Deja.com
>http://www.deja.com/

Very Computer

8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace