Script Hapus Biometric di Database Server KTPEL (LOCAL/ORCL)

Terkadang kita perlu hapus data perekaman di server, ini script lengkapnya, kapan perlunya ?
  1. Setelah pengajuan Penghapusan Biometric Pusat
  2. NIK gagal di panggil di aplikasi Cetak
  3. Kadang dengan Alasan "Biar Enak diliat"
Masuk ke database Perekaman atau database Pencetakan  dan jalankan script dibawah Ini banyak Table yg musti Di hapus, bisa langsung ganti &1 dengan NIK atau bisa langsung jalananin script pake F5 nanti di minta masukin NIK yg mau di Hapus
DELETE BMUSER.BIOMETRIC_EXCEPTIONS WHERE NIK=&1;
DELETE BMUSER.FACE_TEMPLATES WHERE NIK=&1;
DELETE BMUSER.FACES WHERE NIK=&1;
DELETE BMUSER.FINGER_TEMPLATES WHERE NIK=&1;
DELETE BMUSER.FINGERS WHERE NIK=&1;
DELETE BMUSER.IRIS_TEMPLATES WHERE NIK=&1;
DELETE BMUSER.IRIS WHERE NIK=&1;
DELETE BMUSER.SIGNATURE_TEMPLATES WHERE NIK=&1;
DELETE BMUSER.SIGNATURES WHERE NIK=&1;
DELETE BMUSER.DEMOGRAPHICS_AUDIT WHERE NIK = &1;
DELETE BMUSER.AUDITS WHERE NIK = &1;
DELETE BMUSER.BIOMETRIC_DIAGNOSTICS WHERE NIK = &1;
DELETE BMUSER.DUPLICATE_RESULTS WHERE NIK=&1;
DELETE BMUSER.BIOMETRICS_LOSSLESS WHERE NIK=&1;
DELETE BMUSER.CARD_MANAGEMENT WHERE NIK=&1;
DELETE BMUSER.MIDDLEWARE_DIAGNOSTICS WHERE NIK=&1;
DELETE BMUSER.DEMOGRAPHICS WHERE NIK=&1;
COMMIT;

PURGE RECYCLEBIN;

Subscribe to receive free email updates:

0 Response to "Script Hapus Biometric di Database Server KTPEL (LOCAL/ORCL) "

Posting Komentar