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;