The Oracle (tm) Users' Co-Operative FAQ
How do I recover from loss of a datafile that Belongs to the TEMP Tablespace
| Author's name: Allan W. Tham
Author's Email: allanwtham@hotmail.com |
Date written: Feb 8 2002 Oracle version(s): 8.1.7.0.0 |
| I lost a datafile that belongs to TEMP tablespace, how do I recover it? |
This is the simplest form of recovering of a lost of datafile since in temporary tablespace, there is no permanent objects are stored there!!
1. Offline the tablespace
In archivelog - alter database datafile xxx offline immediate In nonarchivelog - alter database datafile xxx offline drop
2.Drop the tablespace
Drop tablespace xxx
3.Remove physical files of the tablespace and recreate them
Further reading: Metalink Note:136180.1 How to Recover a Temporary Tablespace
最后修改时间：2020-04-16 15:13:22
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
