> 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.

We can but not in the same transaction and statements must be ordered.

Regards,
Vlad