datafile [message #37817] |
Thu, 28 February 2002 19:04 |
krishna
Messages: 141 Registered: October 1998
|
Senior Member |
|
|
What is the command for dropping a datafile. I tried to drop the tablespace(including contents) which contained the datafile.
The tablespace gets dropped but the associated datafile does not get dropped. What do i do?
|
|
|
Re: datafile [message #37819 is a reply to message #37817] |
Thu, 28 February 2002 19:13 |
Maryam
Messages: 13 Registered: February 2002
|
Junior Member |
|
|
Try
alter database datafile 'path/filename' offline drop;
Then go to the directory where this file was located an also delete it manually
using rm filename
If it say override protection , chose 'y'
|
|
|