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

From: Anurag Varma <avoracle_at_gmail.com>
Date: 6 Apr 2007 18:40:02 -0700
Message-ID: <1175910002.778726.227240@l77g2000hsb.googlegroups.com>

On Apr 6, 9:31 pm, "Kaka" <kaka...._at_gmail.com> 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!

Issue a
purge tablespace <tablespaceyouwanttodrop>;

to drop the recycle bin objects in that tablespace...

Anurag Received on Fri Apr 06 2007 - 20:40:02 CDT