create smallfile tablespace sales
datafile
size 1G
segment space management auto;
select dbms_metadata.get_ddl('TABLESPACE','SALES') from dual;
create smallfile tablespace sales1
datafile
size 1G;
segment space management auto;
select dbms_metadata.get_ddl('TABLESPACE','SALES1') from dual;