Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can I remove a table from the recycle bin?

Re: Can I remove a table from the recycle bin?

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Sat, 07 Apr 2007 02:19:15 GMT
Message-Id: <pan.2007.04.07.02.19.15@verizon.net> 





On Fri, 06 Apr 2007 18:31:21 -0700, Kaka wrote:



> I am trying to drop a data file from a tablespace.  Oracle does not

> allow because the data file is not empty.  So, I checked the dba segment

> and find there is only 1 file named 'BIN $LCHcrdonOwPgRAADukzrcg==$0'

> which is occupying the data file.   Is there a way I can drop it? 

> Thanks!




By reading the fine manual.


-- 
http://www.mladen-gogala.com


Received on Fri Apr 06 2007 - 21:19:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US