Vlad Khorsun wrote:

>> Vlad Khorsun wrote:
>>
>>> c) Syntax rule 3 means truncated table must not participate in FOREIGN KEY constraints as
>>> master table.
>>> ORACLE relaxed this rule and allow self-referenced constraints. I think we can follow it.
>>>
>>>
>> Can't we also allow it when all detail tables are being truncated on the
>> same transaction?
>>
>
> It is possible to implement, i think. The question is - will we do it or not ? ;)
>

It seems as an important feature for me. Otherwise you will can't
truncate a set of related tables if you don't drop the referential
constraints first.


Adriano