Home » RDBMS Server » Server Utilities » Recovery from the DataFile after the Tablespace got deleted from the Enterprise Manager
Recovery from the DataFile after the Tablespace got deleted from the Enterprise Manager [message #73384] Wed, 07 April 2004 09:45 Go to next message
Jay
Messages: 127
Registered: October 1999
Senior Member
Hi ,

By mistake my Tablespace got deleted from the Enterprise Manager. But the Datafile is still there under oradata. Is there any way to get back the Tablespace back again. 

Report message to a moderator

Re: Recovery from the DataFile after the Tablespace got deleted from the Enterprise Manager [message #73506 is a reply to message #73384] Wed, 12 May 2004 11:01 Go to previous message
croca
Messages: 50
Registered: January 2004
Member
Yes, you must restore the tablespace from backup and recover the tablespace. It is easy if you do backup with RMAN.

Best luck.
if you use RMAN, check www.otools.com.ar

Report message to a moderator

Previous Topic: load 2 files to 1 table with SQL*Loader
Next Topic: ORA-19554 with new versions of Oracle and Legato
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 15:55:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.