Here is the syntax,
Alter tablespace YOUR_TS add datafile '/u01/oradata/ORCL/df01_01.dbf' size 2000M;
Solution for your problem is to add a datafile , b'coz it couldn't allocate sufficient space needed to create your table.
hope this may help you.
thanks




Reply With Quote