OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Droped tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Droped tablespace [message #51063]

Tue, 23 April 2002 07:10

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

Mahesh Rajendran
Messages: 10708
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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 07 08:50:20 CDT 2026