Home -> Usenet -> comp.databases.oracle -> drop tabblespace XXX including contents

drop tabblespace XXX including contents

From: Takeshi Kabata <kabata_at_psrc.isac.co.jp>
Date: 26 May 93 08:16:26 GMT
Message-ID: <93May26.2281_at_psrc.isac.co.jp> 







3 weeks ago, I try to drop tablespace on oracle V6. But it spent very long
time ( about 4days ).



That tablespace is :


size	: 12GB
tables	: over 500




indexes : over 1500



Does anyone know how to drop tablespace fast ? Any help or ideas would be
most appreciated.




Received on Wed May 26 1993 - 10:16:26 CEST












Original text of this message