Hi,
We have 11.2.0.3 database and someone ran a pl/sql package which issued a truncate table command but killed the running of the package whilst this command was being executed
e.g program writes to log
star truncate
issues truncate command on table itself truncate table <table_name>
writes end truncate to log at end
log shows start command but not end truncate
table not truncated but has a thousands of rows less than expected as though truncate had issued partial delete.
My understanding is that a truncate is all or nothing i.e all rows go or all rows remain.
Is this case or is there any circumstance in which truncate can partially complete i.e. delete some rows.
Trying to rule out killed truncate as source of missing rows.
Thanks
Thanks