I have no problem to use dba user to drop it in 9i.
In 10G, the dba user can also execute the command, just the file not get deleted for some reason.

On 4/28/2008 10:43 AM, Michael Peel <oracledba-ezmlmshield-x90895696.[Email address protected] wrote:
>Sys.
>
>Michael Peel
>
>
>-----Original Message-----
>From: Edwards Ed
>[mailto:oracledba-ezmlmshield-x79515521.[Email address protected]
>
>Sent: 28 April 2008 15:42
>To: LazyDBA Discussion
>Subject: RE: drop table space including content and datafile
>
>Did you run it as "sys" or an account that has "DBA" rights?
>
>
>
>-----Original Message-----
>From: Michael Peel
>[mailto:oracledba-ezmlmshield-x79314920.[Email address protected]
>
>Sent: Monday, April 28, 2008 10:38 AM
>To: LazyDBA Discussion
>Subject: RE: drop table space including content and datafile
>
>No you don't.
>I've just done it on 9.2.
>Has one of us had too many redstripes...?
>
>Michael Peel
>
>
>-----Original Message-----
>From: Edwards Ed
>[mailto:oracledba-ezmlmshield-x91634088.[Email address protected]
>
>Sent: 28 April 2008 15:34
>To: LazyDBA Discussion
>Subject: RE: drop table space including content and datafile
>
>BTW, you need to be running Oracle 10G Release 2 and up.
>
>
>-----Original Message-----
>From: Edwards Ed
>[mailto:oracledba-ezmlmshield-x6971716.[Email address protected]
>
>Sent: Monday, April 28, 2008 10:30 AM
>To: LazyDBA Discussion
>Subject: RE: drop table space including content and datafile
>
>Well, well, well!
> It's Qi Cheng! Hehe. How have you been?
>
>To delete the datafiles associated with a tablespace at the same
>time
>that the tablespace is dropped, use the INCLUDING CONTENTS AND DATAFILES
>clause. The following statement drops the users tablespace and its
>associated datafiles:
>
>DROP TABLESPACE users INCLUDING CONTENTS AND DATAFILES;
>
>
>
>
>
>
>
>Please take a few minutes to provide feedback on the quality of service
>you received from our staff. The Department of Education values your
>feedback as a customer. Commissioner of Education Dr. Eric J. Smith
>is
>committed to continuously assessing and improving the level and quality
>of services provided to you.Simply use the link below. Thank you
>in
>advance for completing the survey.
>
>
>http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
>
>
>
>
> -----Original Message-----
>From: Qi Cheng
>[mailto:oracledba-ezmlmshield-x88726861.[Email address protected]
>
>Sent: Monday, April 28, 2008 10:23 AM
>To: LazyDBA Discussion
>Subject: drop table space including content and datafile
>
>drop table space including content and datafile is executed without
>errors.
>The data file not get delelted.
>Any idea?
>
>Same command in 9i worked well, but in 10g, seems has problem.
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>**********************************************************************
>This e-mail is confidential and may be privileged.
>It may only be read, copied and used by the intended recipient.
>
>If you have received it in error please contact the sender immediately
>by return e-mail. Please then delete the e-mail and any copies of
>it
>and do not use or disclose its contents to any person.
>**********************************************************************
>Registered Office: Farncombe House, Broadway, Worcestershire, WR12
>7LJ
>
>AccuRead Limited Registered Number: 3076187 England
>GSL UK Limited Registered Number: 3333860 England
>Global Solutions Limited Registered Number: 3189802 England
>**********************************************************************
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>**********************************************************************
>This e-mail is confidential and may be privileged.
>It may only be read, copied and used by the intended recipient.
>
>If you have received it in error please contact the sender immediately
>by return e-mail. Please then delete the e-mail and any copies of
>it
>and do not use or disclose its contents to any person.
>**********************************************************************
>Registered Office: Farncombe House, Broadway, Worcestershire, WR12
>7LJ
>
>AccuRead Limited Registered Number: 3076187 England
>GSL UK Limited Registered Number: 3333860 England
>Global Solutions Limited Registered Number: 3189802 England
>**********************************************************************
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>


Oracle LazyDBA home page