view counter

On deferred segment creation and truncate

Thanks to Laurent Schneider for this story

One year ago, I wrote about a side effect of deferred segment creation and drop tablespace :

view counter
on deferred segment creation

Today I discoved one more side effect :

In the good old days (I read once that you are old as soon as you start talking about the good old days) and according to the doc :
You cannot truncate the parent table of an enabled foreign key constraint. You must disable the constraint before truncating the table

Read the entire article at its source

view counter