Home » RDBMS Server » Server Administration » open a database
open a database [message #63922] Thu, 25 November 2004 10:10 Go to next message
fengq
Messages: 38
Registered: October 2002
Member
Hi, I deleted one data file by accident, but this datafile is not important so I want to open the <A class=iAs style="COLOR: darkgreen; BORDER-BOTTOM: darkgreen 1px solid; BACKGROUND-COLOR: transparent; TEXT-DECORATION: underline" href="http://www.experts-exchange.com/Databases/Oracle/Q_21220451.html#" target=_blank>database[/url] without it, how can I do it? Thanks

Report message to a moderator

Re: open a database [message #63923 is a reply to message #63922] Thu, 25 November 2004 11:46 Go to previous message
Nino
Messages: 6
Registered: November 2004
Junior Member
Hi, try:

---
SQL>alter database datafile 'path_to_file' offline drop;
Database altered.
SQL>alter database open;
Database altered.
SQL>
---

where 'path_to_file' is the deleted file.
Works well with 9i

greetings

Report message to a moderator

Previous Topic: Problem during upgrade
Next Topic: dgmgrl
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 02 03:34:35 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.