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

I guess upgrading to 10gR2 would be the answer then. It sure works fine here.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)