Home » RDBMS Server » Enterprise Manager » dropping datafile
dropping datafile [message #67767] Wed, 27 February 2002 19:20 Go to next message
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: dropping datafile [message #68193 is a reply to message #67767] Tue, 21 January 2003 12:04 Go to previous message
Samir
Messages: 32
Registered: April 2002
Member
try this command
Drop tablespace tablespace_name and datafiles;
Previous Topic: How to lonon to Oracle Enterprise Manager
Next Topic: loader problem
Goto Forum:
  


Current Time: Thu Mar 28 21:19:44 CDT 2024