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 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.
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 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.
扫一扫
3921
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
