Re: Using DROP TABLESPACE INCLUDING CONTENTS
From: <dlm_at_hermes.dlogics.com>
Date: 30 Jan 92 22:41:46 CST
Message-ID: <1202.29887f2a_at_hermes.dlogics.com>
Date: 30 Jan 92 22:41:46 CST
Message-ID: <1202.29887f2a_at_hermes.dlogics.com>
kpalm_at_athena.qualcomm.com (Kent Palm) writes:
> So, I configured the database such that I now have a tablespace called
> INDEX1. The only objects allowed in this tablespace are indexes. Now, the
> question is, can I take that tablespace offline and drop it without first
> dropping all the indexes it contains?
I can report, having dropped an indexes-only tablespace including contents, that this measure does work exactly as you described it.
-- Dave Mausner, Senior Consultant / Datalogics Inc / Chicago IL / 312-266-4450 dlm_at_dlogics.com Motto: Just show me the codeReceived on Fri Jan 31 1992 - 05:41:46 CET