Re: HELP with dropping tablespaces needed!
From: <Paul.deAnguera_at_ci.seattle.wa.us>
Date: 1996/09/30
Message-ID: <52p7sv$eq5_at_lal.interserv.com>#1/1
Date: 1996/09/30
Message-ID: <52p7sv$eq5_at_lal.interserv.com>#1/1
> SQLDBA>connect internal;
> SQLDBA>alter tablespace <tablespace_name> offline;
> SQLDBA>drop tablespace <tablespace_name> INCLUDING CONTENTS;
>
> But, as I sed, I gaveup after more than 2 hours.
> Maybe, I didn't use the right solution?
> Can anyone help?
> Thanks, Victor.
>
>>>>
Looks OK to me. All I can suggest is that the contents might slow you down due to nested
drops caused by constraints and dependencies. Drops run in a matter of seconds for me.
- Paul de Anguera, City of Seattle / HRIS