Re: 10g recycling bin foreign key behavior

Jack wrote:
> Hi Dan;
>
> Yes! I am seeing something very different. Here's the relevant snippet
> of script:
>
> DROP TABLE dept CASCADE CONSTRAINTS;
>
> PROMPT
> PROMPT Is the dept table in the recycle bin?
> PROMPT
>
> SELECT original_name,
> object_name,
> type
> FROM dba_recyclebin
> WHERE original_name = 'DEPT';
>
>
> Result:
>
> Table dropped.
>
> Is the dept table in the recycle bin?
>
> no rows selected
>
> I couldn't figure out why it wasn't in the recycle bin, but now I'm
> more anxious about the FK on my emp table still being there and
> "enabled" at that!
>
> Thanks for shedding any light, Jack
>

Maybe recyclebin is disabled? There is an underscore parameter for that: "_recyclebin=false"
In 10gr2 one can disable it either by:
alter session set recyclebin=off; -- for session or
alter system set recyclebin=off; -- for system

Anurag Received on Fri Oct 14 2005 - 21:49:41 CDT