alter table B_F_CLEAN_JOB
add constraint ID_PK primary key (ID)
using index ;
-- Create/Recreate check constraints
alter table B_F_CLEAN_JOB
add constraint BUILD_INDEX_CHECK
check (BUILD_INDEX in ('NO','YES'));
alter table B_F_CLEAN_JOB
add constraint CLEAN_MEHTOD_CHECK
check (CLEAN_MEHTOD in ('TRUNCATE','DROP','DETELE'));
alter table B_F_CLEAN_JOB
add constraint OFFSET_CHECK
check ((regexp_like(offset,'^[0-9] MONTHS')
and regexp_replace(offset,'^([0-9])(.*)','\1')
or(regexp_like(offset,'^[0-9][0-9][0-9][0-9] DAYS'))
or(regexp_like(offset,'^[0-9][0-9][0-9] DAYS'))
or(regexp_like(offset,'^[0-9][0-9] DAYS'))
or(regexp_like(offset,'^[0-9] DAYS'))
or(regexp_like(offset,'^{0}[0-9] MONTHS'))
or(regexp_like(offset,'^{1}[0-2] MONTHS'))
or offset='0');
alter table B_F_CLEAN_JOB
add constraint ID_PK primary key (ID)
using index ;
-- Create/Recreate check constraints
alter table B_F_CLEAN_JOB
add constraint BUILD_INDEX_CHECK
check (BUILD_INDEX in ('NO','YES'));
alter table B_F_CLEAN_JOB
add constraint CLEAN_MEHTOD_CHECK
check (CLEAN_MEHTOD in ('TRUNCATE','DROP','DETELE'));
alter table B_F_CLEAN_JOB
add constraint OFFSET_CHECK
check ((regexp_like(offset,'^[0-9] MONTHS')
and regexp_replace(offset,'^([0-9])(.*)','\1')
or(regexp_like(offset,'^[0-9][0-9][0-9][0-9] DAYS'))
or(regexp_like(offset,'^[0-9][0-9][0-9] DAYS'))
or(regexp_like(offset,'^[0-9][0-9] DAYS'))
or(regexp_like(offset,'^[0-9] DAYS'))
or(regexp_like(offset,'^{0}[0-9] MONTHS'))
or(regexp_like(offset,'^{1}[0-2] MONTHS'))
or offset='0');