RE: drop table space including content and datafile

RE: drop table space including content and datafile

 

  

Are you logged on as "sysdba" or a user with "DBA" rights"?





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-x44667870.[Email address protected]
Sent: Monday, April 28, 2008 10:54 AM
To: LazyDBA Discussion
Subject: Re: drop table space including content and datafile

in my case, 9i server worked very well. The new installed 10.2.0.3, has
problem.
tablespace got dropped, but the files remain.

On 4/28/2008 10:34 AM, Edwards Ed
<oracledba-ezmlmshield-x91634088.[Email address protected] wrote:
>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
>
>
>
>



---------------------------------------------------------------------
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