Home » RDBMS Server » Server Administration » Re: missing a datafile
Re: missing a datafile [message #51096] Thu, 25 April 2002 01:13
smk
Messages: 5
Registered: November 2001
Junior Member
go to svrmgr and connect as dba. Then if you database is running then just give this command

alter tablespace
offline drop.

If database is not up then use

1) startup mount
2) alter tablespace
offline drop.
3) alter database open

I think this will help you solve the problem.

All the best

Jay

Report message to a moderator

Previous Topic: problem in TCPS
Next Topic: DBA BOOK
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

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