Alter Tablespace Command

Login as a System User

Alter Tablespace TableSpaceName ADD datafile '/data/prod/db/apps_st/data/xxxx.dbf' SIZE 500M;