扩展临时表空间,不能用datafile,只能用tempfile
错误语句:
ALTER TABLESPACE backup_temp ADD datafile '/data/oradata/backup/backup_temp02.dbf' size 150m autoextend on next 50m MAXSIZE unlimited;
正确语句:
ALTER TABLESPACE backup_temp ADD tempfile '/data/oradata/backup/backup_temp02.dbf' size 150m autoextend on next 50m MAXSIZE unlimited;
------------正 文 已 结 束, 感 谢 您 的 阅 读 (折雨的天空)--------------------
转载请注明本文标题和链接:《ORA-03217: invalid option for alter of TEMPORARY TABLESPACE》
发表评论