How do you resize a data file?
Sapna Malik
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;