create tablespace sehr datafile 'E:\ORACLEDB\SEHR.DBF'

修改为自动扩展

alter database datafile 'E:\ORACLEDB\SEHR.DBF' autoextend on next 100M maxsize 20000M

增加文件

alter tablespace sehr
add datafile 'E:\ORACLEDB\SEHR2.DBF' size 2000M autoextend on next 100M maxsize 20000M

?

=========================================================

语法描述：

CREATE [UNDO] TABLESPACE tablespace_name

[DATAFILE datefile_spec1 [,datefile_spec2] ......

[ { MININUM EXTEN T integer [k|m]

| BLOCKSIZE integer [k]

|logging clause

|FORCE LOGGING

|DEFAULT { data_segment_compression} storage_clause

|[online|offline ]

|[PERMANENT|TEMPORARY ]

|extent_manager_clause

|segment_manager_clause } ]

?