OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » drop datafile

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

drop datafile [message #59066]

Sun, 26 October 2003 23:08

M. Khaled
Messages: 67
Registered: April 2002

Member

how could i drop datafile not tablespace.
pls help

Report message to a moderator

Re: drop datafile [message #59070 is a reply to message #59066]

Mon, 27 October 2003 04:23

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi orak,
This should help you

ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/users03.dbf' OFFLINE DROP;

hth
Uwe

Report message to a moderator

Re: drop datafile [message #59072 is a reply to message #59066]

Mon, 27 October 2003 06:01

Suresh.H.T
Messages: 9
Registered: February 2002

Junior Member

Hi,
you have to delete it manually from the respective folder.
Suresh.H.T

Report message to a moderator

Re: drop datafile [message #59079 is a reply to message #59066]

Mon, 27 October 2003 12:30

Thiru
Messages: 1089
Registered: May 2002

Senior Member

Even when you do a
Alter database datafile 'filename' offline drop;

the file remains in the data dictionary with a status of 'RECOVER' or 'OFFLINE' . You will need to drop the tablespace to completely get rid of the file.

-Thiru

Report message to a moderator

Previous Topic:	Buffer Cache Hit Ratio - 1235%, what happened?
Next Topic:	OUI alert installing Oracle 9i on HP Tru64

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:38:16 CDT 2024