| 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'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
