Re: Problem dropping tablespace

From: Uldis Pavuls <U.Pavuls_at_konts.lv>
Date: Wed, 11 Aug 1999 12:15:10 +0300
Message-ID: <7orevp$kft@news.latnet.lv>

See DROP TABLESPACE .... INCLUDING CONTENTS CASCADE CONSTRAINTS in SQL Reference. You might
need start instance with NOMOUNT option, though. I have done it once, but i do not remember exact details. Nevertheless it might be done. HTH ,
Uldis

Vijay Mayadas wrote in message <37b0a191_at_news1.us.ibm.net>...
>I've lost the datafile for one of my tablespaces and wish to drop the
>tablespace and recreate it.
Received on Wed Aug 11 1999 - 04:15:10 CDT