SELECT tablespace_name,
file_id,
file_name,
round(bytes / (1024 * 1024), 0) total_space
FROM dba_data_files
ORDER BY tablespace_name;
create tablespace QXDB datafile 'D:\app\oracle11g\oradata\orcl\QXDB.dbf'
size 500M autoextend on next 50M maxsize 2014M extent management local;