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–;--顺利执行