Home » RDBMS Server » Server Administration » Drop datafile and not tablespace HELP HELP
Drop datafile and not tablespace HELP HELP [message #55807] Mon, 17 February 2003 12:44 Go to next message
Maria
Messages: 57
Registered: August 1999
Member
Hi all
I by miskate droped first the datafile and not the tablespace, now I'm getting the following error message
ORA-01157: cannot identify/lock data file 71 - see DBWR trace file
ORA-01110: data file 71: '/u02/oradata/DEVDB/is_lisa_ts01.DBF'
SVRMGR>
can somone please help

Thnaks
Maria

Report message to a moderator

Re: Drop datafile and not tablespace HELP HELP [message #55810 is a reply to message #55807] Mon, 17 February 2003 12:52 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hello,
try to put that datafile in Offline state during mount state and later open the database..

Once the database is Opened Drop the tablespace..

Also see what others say regarding this..

sai

Report message to a moderator

Re: Drop datafile and not tablespace HELP HELP [message #55829 is a reply to message #55807] Tue, 18 February 2003 18:33 Go to previous message
sharan alva
Messages: 57
Registered: November 1999
Member
Maria,
Once you drop a datafile consider that your tablespace is gone. If you database is up and running then you may want to salvage the objects (if the tablespace contains more than one datafile) and drop the tablespace.

If it is down then follow the steps outlinded by Sai and open the db and drop the tbsp.

Sharan

Report message to a moderator

Previous Topic: Highwater_Session
Next Topic: LGWR: terminating instance due to error 227
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:33:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.