DROP TABLESPACE MYSPACENAME INCLUDING contents; CREATE TABLESPACE MYSPACENAME DATAFILE 'ts1_filename.dbf' SIZE 2000m autoextend on NEXT 1000m maxsize unlimited; alter tablespace MYSPACENAME coalesce;
DROP TABLESPACE MYSPACENAME INCLUDING contents; CREATE TABLESPACE MYSPACENAME DATAFILE 'ts1_filename.dbf' SIZE 2000m autoextend on NEXT 1000m maxsize unlimited; alter tablespace MYSPACENAME coalesce;