Home » RDBMS Server » Server Administration » Droped tablespace
Droped tablespace [message #51063] Tue, 23 April 2002 07:10 Go to next message
jack
Messages: 123
Registered: September 2000
Senior Member
Dear All,

How do I recover my droped tablespace without cold backup or EXPORT files ? The database is not in archive log mode. I did not delete the related OS files.

Could any one give me some suggestion ?

Many thanks

Jack

Report message to a moderator

Re: Droped tablespace [message #51069 is a reply to message #51063] Tue, 23 April 2002 07:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
pls forget about recovering the tablespaces, if you dont have any backup / export .
btw, wats the version of oracle?

Report message to a moderator

Re: Droped tablespace [message #51080 is a reply to message #51069] Tue, 23 April 2002 19:04 Go to previous message
Jen
Messages: 23
Registered: June 2001
Junior Member
hi,

You can try create tablespace to use all related OS files. Don't be afraid of trying.

Report message to a moderator

Previous Topic: How make constraint names longer than 30 letters?
Next Topic: How Oracle Handles the date
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 09 18:52:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.