Alter tablespace: Data Files and Tempfiles

ALTER TABLESPACE mytbs ADD DATAFILE /ora100/oracle/mydb/mydb_mytbs_01.dbf' SIZE 100M;
ALTER TABLESPACE mytemp ADD TEMPFILE '/ora100/oracle/mydb/mydb_mytemp_01.dbf' SIZE 100M;
ALTER TABLESPACE mytemp AUTOEXTEND OFF;
ALTER TABLESPACE mytemp AUTOEXTEND ON NEXT 100m MAXSIZE 1G;