ORA-03217: 更改 TEMPORARY TABLESPACE 的选项无效

最新推荐文章于 2022-07-29 07:50:51 发布

转载最新推荐文章于 2022-07-29 07:50:51 发布 · 3.4k 阅读

文章标签：

#数据库

本文解释了为何不能使用ALTER DATABASE或ALTER TABLESPACE命令来修改Oracle 9i及以上版本的本地管理临时表空间，并阐述了无需备份这些表空间的原因。

symptom: ALTER TABLESPACE BEGIN BACKUP fails symptom: ORA-03217: invalid option for alter of TEMPORARY TABLESPACE cause: Alter database and alter tablespace will not work on locally managed
tempfiles as they have no reference in the data dictionary. There is no need
to back up the tempfiles as they are used and destroyed every time you start up
and shut down the database.

Oracle9i 以上本地管理的temp表空间是不能使用 alter database , alter tablespace 来更改的。因为他们

在数据字典中没有参考信息。也不需要备份tempfile 文件。

There is no need to backup the temporary locally manged tablespaces because:

1. Locally managed tempfiles are always set to NOLOGGING mode. So thus will
have no undo.
2. Extents are managed by bitmap in each datafile to keep track of free or
used status of blocks in that datafile.
3. The data dictionary does not manage the tablespace.
4. Rollback information is not generated because there is no update on the
data dictionary.
5. Media recovery does not recognize tempfiles.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-425536/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-425536/