is there any risk to issue the command "alter table truncate partition update global indexes" agai
Hi all,
my enironment is 11.2.0.3 database. there are lots of global indexes for the large tables. from the test, truncate one partition takes nearly one hours, it is impossible to stop applications to truncate these partitions.
is there any risk to issue the command "alter table truncate partition update global indexes" against the online system? it is not allowed to stop the database, will it be the performance bottleneck? it will block other session?, especailly, when it is to update the global indexes. it is online sytem, there are lots of DML operations.
the bad thing that meet some unknown bug.
1