如果仅仅是从语法来看
create tablespace abc_dat
datafile'file_name/abc_dat01.dbf"'size 1000m autoextend on next 1m maxsize 5000m;
create tablespace dbc_idx
datafile'file_name/abc-idx01.dbf'size XXXXmautoextend on next 1m maxsize XXXXm;
若为本地管理.则后跟上extent management local