How to reset restrictions of all storage containers?

Restrictions can be reset in 2 steps by directly executing the SQLs against the target database as explained below:

Step 1: Clear all restrictions

delete from os_stor_cont_spec_classes;
delete from os_stor_cont_spec_types;
delete from os_stor_container_cps;
delete from os_stor_cont_comp_spec_classes;
delete from os_stor_cont_comp_spec_types;
delete from os_stor_container_comp_cps;
commit;


Step 2: Add default restrictions to allow all kinds of specimens

insert into 
  os_stor_cont_comp_spec_classes(storage_container_id, specimen_class) 
select 
  c.identifier as storage_container_id, t.spmn_class as specimen_class
from
  os_storage_containers c, 
  (
    select 'Cell' as spmn_class from dual 
    union 
    select 'Fluid' from dual 
    union 
    select 'Molecular' from dual 
    union 
    select 'Tissue' from dual
  ) t 
where 
  c.activity_status != 'Disabled';

commit;