Script Hapus Biometric di Database Server KTPEL (LOCAL/ORCL)
Terkadang kita perlu hapus data perekaman di server, ini script lengkapnya, kapan perlunya ?
- Setelah pengajuan Penghapusan Biometric Pusat
- NIK gagal di panggil di aplikasi Cetak
- 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;
0 Response to "Script Hapus Biometric di Database Server KTPEL (LOCAL/ORCL) "
Posting Komentar