ORACLE数据库增加SYSTEM和USER表空间大小

1.SYSTEM:
ALTER TABLESPACE SYSTEM ADD DATAFILE ‘D:\app\Administrator\oradata\orcl\SYSTEM02.DBF’ SIZE 100M

alter database datafile ‘D:\app\Administrator\oradata\orcl\SYSTEM02.DBF’ autoextend on next 50m maxsize unlimited–全部执行之后再提交

2.USER
一定要全部执行之后再提交：

ALTER TABLESPACE USERS ADD DATAFILE ‘D:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS05.DBF’ SIZE 500M;

alter database datafile ‘D:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS05.DBF’ autoextend on next 50m maxsize unlimited–;--顺利执行