Deploy New Data
LexBuild was designed to restore any snap shoot data. This feature can be used to restore latest data to testing LexBuild system for simulation test and generate annual LEXICON. The procedures are described as follows:
Sometimes, empty lexRecords are generated and insert into database because users double click on the approval items before the SQL execution is completed. Make sure remove all these illegal lexRecords before generate them into backup files.
delete from LEX_RECORD where eui = 'E0000000'
1 1 6 (drop not delete => faster & cleaner) 11
1 1 1 11
1 1 2 11