Call_book_info
MOBILE_ID mobile number VARCHAR2 (12)
CALLIN_TIME inbound time Date
CALLOUT_TIME exhaled time Date
The STATUS STATUS CHAR (1)
In a large quantity after the operation, data record up to 1 million, an estimated 20000 repeat MOBILE_ID, hereby request delete duplicate number (only one), because business table, the table is deleted should not affect the normal use of the business, write a stored procedure can realize the function of remove duplicate number,
Requirements are as follows:
(1) in order to ensure the delete data will then be checked, should do first when delete backup, backup is not successful, cannot be deleted,
(2) for logging, such as delete the time spent, delete article how much success, failure operation information, such as how many article
(3) if there is a performance problem, to track the reason, the trace file generated is analyzed, improved program,
CodePudding user response:
Typical to repeat questions but needs some conditions such as going to repeat what are the rules, do not want to delete