Oracle数据库中表空间3-修改表空间大小
增加表空间大小方式2：增加新的数据文件;SQL> alter tablespace myspace 2 add datafile 'D:\APP\SQLTEST\SELF\TEST02.DBF' size 30m 3 autoextend on 4 next 5m 5 maxsize unlimited 6 ;表空间已更改。SQL> select file_name, bytes from dba_data_files;FILE_NAME BYTES-------------------------------------------------- ----------D:\APP\JGWANG\ORADATA\ORCL\USERS01.DBF 5242880D:\APP\JGWANG\ORADATA\ORCL\UNDOTBS01.DBF 104857600D:\APP\JGWANG\ORADATA\ORCL\SYSAUX01.DBF 587202560D:\APP\JGWANG\ORADATA\ORCL\SYSTEM01.DBF 734003200D:\APP\JGWANG\ORADATA\ORCL\EXAMPLE01.DBF 104857600D:\APP\SQLTEST\SELF\TEST.DBF 62914560D:\APP\SQLTEST\SELF\TEST02.DBF 31457280已选择7行。SQL>
