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
Previous Topic: problem in TCPS
Next Topic: DBA BOOK
Goto Forum:
  


Current Time: Wed Dec 25 08:53:35 CST 2024