ADD DATAFILE TO USERDATA

alter  tablespace userdata add datafile 'C:\oraclexe\oradata\xe\userdata2.dbf' size 2m;



Statement processed.


0.55 seconds



SELECT TABLESPACE_NAME, FILE_NAME, FILE_ID
FROM DBA_DATA_FILES
WHERE TABLESPACE_NAME = 'USERDATA';




USERDATA C:\ORACLEXE\ORADATA\XE\USERDATA1.DBF 5
USERDATA C:\ORACLEXE\ORADATA\XE\USERDATA2.DBF 7

SELECT  FILE_NAME, BLOCKS
   FROM DBA_DATA_FILES where TABLESPACE_NAME = 'USERDATA';

FILE_NAME                                                       BLOCKS
C:\ORACLEXE\ORADATA\XE\USERDATA1.DBF    256
C:\ORACLEXE\ORADATA\XE\USERDATA2.DBF    256