Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> drop tablespace including contents -- very slow

drop tablespace including contents -- very slow

From: <chrisoc_at_ans.net>
Date: Mon, 24 Jan 2000 17:37:03 GMT
Message-ID: <86i2jv$ngn$1@nnrp1.deja.com>

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. Received on Mon Jan 24 2000 - 11:37:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US