DA Morgan wrote:
> 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.
Yes I'd agree. In the way its stated .. it sure does look like a bug.
Anurag
Received on Sat Oct 15 2005 - 13:32:23 CDT
