K-edge x-ray absorption spectra in transition-metal oxides beyond the single-particle approximation: Shake-up many-body effects