Re: drop tablespace including contents -- very slow

From: <chrisoc_at_ans.net>
Date: Mon, 24 Jan 2000 20:09:20 GMT
Message-ID: <86ibha$v0d$1@nnrp1.deja.com>

I tried again, first taking the datafile offline and dropping it, then taking the tablespace offline. It didn't help. I have a call in to Oracle Support. This is very weird.

Chris O'Connor

In article <86i2jv$ngn$1_at_nnrp1.deja.com>, chrisoc_at_ans.net wrote:
>
>
> I am running 8.1.5 on Solaris and using raw volumes for some
> of the tablespaces.
>
> I tried "drop tablespace raw_tabsp including contents" and
> was surprised to see the command still running after 30 minutes.
> It is almost 2 GB in size.
> I didn't think that this operation would use RBSes.
> What could be taking so much time?
>
> Chris O'Connor
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 24 2000 - 14:09:20 CST