Table space Create & Delete

Create Table Space

CREATE TABLESPACE TABLESPACENAME
  LOGGING
  DATAFILE 'DIRECTORY' SIZE 10M
  AUTOEXTEND ON NEXT 10M
  MAXSIZE UNLIMITED
  EXTENT
  MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO
;

Delete Table Space

ALTER TABLESPACE TABLESPACENAME OFFLINE;
DROP TABLESPACE TABLESPACENAME
INCLUDING CONTENTS AND DATAFILES
CASCADE CONSTRAINTS;