OraFAQ Forum: Server Utilities » drop datafile first then tablespace HELP

Home » RDBMS Server » Server Utilities » drop datafile first then tablespace HELP

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

drop datafile first then tablespace HELP [message #71995]

Mon, 17 February 2003 12:45

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

Thanks
Maria

Report message to a moderator

Re: drop datafile first then tablespace HELP [message #72000 is a reply to message #71995]

Tue, 18 February 2003 08:25

Arvind
Messages: 23
Registered: December 2001

Junior Member

Hi,

When you are sure you can't get the datafile back you can issue:

svrmgrl> alter database "datafile" offline drop;

Arvind L

Report message to a moderator

Previous Topic:	Loading data in more than one table using SQL Loader
Next Topic:	sql loader sum in .ctl file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 07:12:09 CST 2024