Anurag Varma wrote:
> 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
I don't think that would explain the reported behaviour. But then I'm
not sure anything logical will either.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Oct 15 2005 - 11:52:02 CDT
