Adding Another Datafile

[DanAuber]

can someone remind me of the syntax to do this please as I have long forgotten<br><br>thanks <p>Dan Auber<br><a href=mailtoanAuber@aol.com>DanAuber@aol.com</a><br><a href=

http://members.aol.com/_ht_a/danauber/myhomepage/>Dan

Auber's Home Page</a><br>

 

[rossman]

ALTER TABLESPACE &quot;TBLSPCE_NAME&quot; ADD DATAFILE 'D:\DATABASE\MY_DATFILE2.ORA' SIZE 100M;