Truncate reference partitioned tables
I have problem truncating tables that use Oracle 11g reference partitioning. Normally, before truncating table you need to disable all constraints on the table. But in the case when reference partitioning is used, you cannot disable FK constraints and therefore TRUNCATE operation will fail.
Does anyone know workaround for this issue? Using DELETE statement is not solution for me because of huge number of rows in the tables.
Thanks,
Samir