OH_DeleteFlag: what is the meaning of the the values

Document ID : KB000088236
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
The OH_Deleteflag of table OH can have one of these values:
 
ValueDescription
0'Normal' object.
1Object moved to recycle bin, including version objects of the deleted object
2Version Control Object
5Object marked by DB Unload to be removed while reorg-run

Example:
SQL> SELECT
  2      oh_idnr,
  3      oh_deleteflag,
  4      oh_client,
  5      oh_name
  6  FROM
  7      oh
  8  WHERE
  9      oh_name LIKE '%JAC#MIGRATION.DUMMY.JOBS%'
 10  ORDER BY oh_name;

 OH_IDNR OH_DELETEFLAG  OH_CLIENT OH_NAME
-------- ------------- ---------- ---------------------------------------------------
 2261415             0       1977 JAC#MIGRATION.DUMMY.JOBS
 2276368             1       1977 JAC#MIGRATION.DUMMY.JOBS.NEW.1.OLD.20161124.110909
 2276369             1       1977 JAC#MIGRATION.DUMMY.JOBS.NEW.1.OLD.20161124.110924
 2276367             1       1977 JAC#MIGRATION.DUMMY.JOBS.NEW.1_0002276367
 2276366             2       1977 JAC#MIGRATION.DUMMY.JOBS.OLD.20161124.110823
 
Resolution:
N/A