> 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 ? ;)

Regards,
Vlad