create and drop tablespace local filesystem

 

DROP TABLESPACE <tablespacename> INCLUDING CONTENTS AND DATAFILES;

create tablespace <tablespacename> datafile '<path><filename>' SIZE 10G ONLINE;