Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Deleting 8,000 bib records with same oclc number

    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    Is there any way a person can get rid system records that have the same oclc number? They
    all share the 049 code of ABCD.
    We have a record on our test machine that has oclc 286972 and there are about 8000 system records
    that were created somehow through loader by mistake. There are no holdings attached to these
    records.

    Is there any way to get rid of the 8000+ systems numbers also?

    Resolution:
    I ran p_ret_03 like this:

    csh -f $aleph_proc/p_ret_03 ABC01,oclc286972docs,pno=0000286972 > & abc01_p_ret_03.0307.js &

    That has created a file $alephe_scratch/oclc286972docs which has the record numbers in it.

    You need to use this file as input to p_manage_33 which will delete all the records. (If you want to save one of them, you could do so by deleting the line for that particular record number from oclc286972docs.)

    Before running p_manage_33, you should check the BATCH-DELETE lines in odn01/tab/check_doc . (The setting you have right now:

    !BATCH-DELETE check_doc_delete_lkr
    !BATCH-DELETE check_doc_delete_item
    BATCH-DELETE check_doc_delete_order
    BATCH-DELETE check_doc_delete_copies
    BATCH-DELETE check_doc_delete_loan
    !BATCH-DELETE check_doc_delete_hold

    will allow it to delete all of these.) The setting of BATCH-DELETE lines is discussed in KB 5726.

    Additional Information

    faq


    • Article last edited: 10/8/2013
    //doorbell.io feedback widged