Home » Other » General » How to delete files without restarting or shutdown?
How to delete files without restarting or shutdown? [message #146390] Thu, 10 November 2005 02:50 Go to next message
papadoms
Messages: 1
Registered: November 2005
Junior Member
Hi,
How can i delete files without shuting-down or restarding Oracle?


Razz

Report message to a moderator

Re: How to delete files without restarting or shutdown? [message #146434 is a reply to message #146390] Thu, 10 November 2005 07:12 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Look here
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dfiles.htm#16235
Which says
Quote:


There is no SQL statement that specifically drops a datafile. The only means of dropping a datafile is to drop the tablespace that contains the datafile

So you should be doing what is been stated here, with caution.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/tspaces.htm#1011

Report message to a moderator

Previous Topic: Can't print oracle file utf-8 on linux
Next Topic: UDL Connection to Oracle10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 28 13:01:42 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.