i've a primary key which is referred by 4-5 tables foreign key. since i want to truncate the table containing primary key i was not able to do so. but after suffixin CASCADE to the alter command i was able to disable.
when enabling i'm able to enable the primary key but the foreign keys were still in the disable state.
how do i enable them generically.
i don't want to enable manually.
select 'ALTER TRIGGER ' || trigger_name || ' ENABLE;' from user_triggers;
If you spool that into a text file you'll have the commands you need to re-enable everything.