Re: sppurge (Statspack Purge) does not seem to free up space

bdbafh_at_gmail.com wrote:

> SQL> drop tablespace :tablespace_name including contents including
> datafiles;
>
> -bdbafh

For anyone trying this the correct syntax is:

DROP TABLESPACE <tablespace_name>
INCLUDING CONTENTS AND DATAFILES
CASCADE CONSTRAINTS;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)