Create:
CREATE TABLESPACE DATA05 DATAFILE 'D:\app_db12c\oracle\oradata\orcl\sample01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M;
Extend:
ALTER TABLESPACE DATA05 ADD
DATAFILE 'D:\app_db12c\oracle\oradata\orcl\sample02.dbf' SIZE 1M
AUTOEXTEND ON NEXT 1M;
Delete:
DROP TABLESPACE DATA05 INCLUDING CONTENTS AND DATAFILES;
