Re: 10g recycling bin foreign key behavior

From: Jack <jreid_at_stirlingonline.com>
Date: 14 Oct 2005 05:19:32 -0700
Message-ID: <1129292372.066006.211050@f14g2000cwb.googlegroups.com>

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 Received on Fri Oct 14 2005 - 07:19:32 CDT