ALTER TABLESPACE ADD DATAFILE SIZE 

SQL SERVER: ALTER DATABASE AdventureWorks2012 ADD FILE ( NAME = Test1data, FILENAME = 'C:\t1data.ndf', SIZE = 5MB ); GO Oracle: ALTER DATABASE DATAFILE 'filename' RESIZE size;