Cacher is the code snippet organizer for pro developers

SELECT FILE_NAME, BYTES FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'USERS';

ALTER TABLESPACE USERS ADD DATAFILE 'E:\SOFTWARE\ORACLE\ORADATA\MRC2ORCL\USERS02.DBF' SIZE 2G AUTOEXTEND ON NEXT 100M;