The TRUNCATE statement could not be processed for one of the following
* The TRUNCATE statement would result in the activation of DELETE
triggers. However, the statement specifies RESTRICT WHEN DELETE
TRIGGERS (implicitly or explicitly). This can occur when DELETE
triggers exist for the table to be truncated, and the result of the
TRUNCATE statement would activate the triggers.
* The table to be truncated is the parent table in a referential
It is true that the table to be truncted is the parent table in a referential constraint.
In such a case, what is the way to truncate to the data?
I tried the following too:
alter table TABLE_A activate not logged initially with empty table;
IMPORT FROM NUL OF DEL REPLACE INTO TABLE_A.
None of these worked.
Can anyone guide me through this?