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博客 ” ，链接：https://blog.itpub.net/35489/viewspace-425536/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
SQL优化之操作符篇(zt)
请登录后发表评论
登录
全部评论
