Oracle: Drop Tablespace in Oracle Database with Example

Friday, 19 April 2013

Note that dropping a tablespace removes the internal pointers from Oracle ; you still need to remove the file using OS commands.

ALTER TABLESPACE ts01 OFFLINE IMMEDIATE ;

DROP TABLESPACE ts01 INCLUDING CONTENTS ;

/* then, delete data files using O/S commands */