Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss'
CREATE TABLE locations AS
SELECT level AS location_id,
   'Door ' || level AS location_name,

CASE    round(dbms_random.value(1,3)) 
        WHEN 1 THEN 'A' 
        WHEN 2 THEN 'T' 
        WHEN 3 THEN 'G' 
     END AS location_type

FROM   dual
CONNECT BY level <= 25;
25 rows affected

with a as (
  select
    date '2021-01-01'
    + to_dsinterval('0 23:30:00')
    as start_dt_param
  from dual
)
, date_gen as (
  select
    location_id
    , start_dt_param
    , start_dt_param + (row_number() over(order by location_id) - 1)
        * interval '10' minute as start_dt
    , start_dt_param + (row_number() over(order by location_id) - 1)
        * interval '10' minute + interval '5' minute as end_dt
from a
  cross join locations
)
select
  location_id
  , start_dt
  , end_dt
from date_gen
where end_dt < trunc(start_dt_param + 1)


LOCATION_ID
START_DT
END_DT


1
2021-01-01 23:30:00
2021-01-01 23:35:00

2
2021-01-01 23:40:00
2021-01-01 23:45:00

3
2021-01-01 23:50:00
2021-01-01 23:55:00


create table schedule(
       schedule_id NUMBER(4),
       location_id number(4),
       start_date DATE,
       end_date DATE,
         CONSTRAINT start_min check (start_date=trunc(start_date,'MI')),   
       CONSTRAINT end_min check (end_date=trunc(end_date,'MI')),
 CONSTRAINT end_gt_start CHECK (end_date >= start_date)/*,
CONSTRAINT same_day CHECK (TRUNC(end_date) = TRUNC(start_date))*/
      );
create or replace procedure populate_schedule (
  p_schedule_id in number
  , p_start_date in date
) as
begin
  insert into schedule (schedule_id, location_id, start_date, end_date)
  select
    p_schedule_id
    , location_id
    , p_start_date + (rownum - 1) * interval '10' minute
    , p_start_date + (rownum - 1) * interval '10' minute + interval '5' minute
  from locations
  /*Put your order of location assignment here*/
  order by location_id
  /*The number of 10-minute intervals before midnight from the first end_date*/
  fetch first ((trunc(p_start_date + 1) - p_start_date + 1/24/60*5)*24*60/10) rows only
  ;
  
  commit;
end;
/
begin
  populate_schedule(1, timestamp '2020-01-01 23:37:00');
  populate_schedule(2, timestamp '2020-01-01 23:35:00');
  populate_schedule(3, timestamp '2020-01-01 23:33:00');
end;/
1 rows affected

select *
from schedule
order by schedule_id, start_date


SCHEDULE_ID
LOCATION_ID
START_DATE
END_DATE


1
1
2020-01-01 23:37:00
2020-01-01 23:42:00

1
2
2020-01-01 23:47:00
2020-01-01 23:52:00

2
1
2020-01-01 23:35:00
2020-01-01 23:40:00

2
2
2020-01-01 23:45:00
2020-01-01 23:50:00

2
3
2020-01-01 23:55:00
2020-01-02 00:00:00

3
1
2020-01-01 23:33:00
2020-01-01 23:38:00

3
2
2020-01-01 23:43:00
2020-01-01 23:48:00

3
3
2020-01-01 23:53:00
2020-01-01 23:58:00

LOCATION_ID	START_DT	END_DT
1	2021-01-01 23:30:00	2021-01-01 23:35:00
2	2021-01-01 23:40:00	2021-01-01 23:45:00
3	2021-01-01 23:50:00	2021-01-01 23:55:00

SCHEDULE_ID	LOCATION_ID	START_DATE	END_DATE
1	1	2020-01-01 23:37:00	2020-01-01 23:42:00
1	2	2020-01-01 23:47:00	2020-01-01 23:52:00
2	1	2020-01-01 23:35:00	2020-01-01 23:40:00
2	2	2020-01-01 23:45:00	2020-01-01 23:50:00
2	3	2020-01-01 23:55:00	2020-01-02 00:00:00
3	1	2020-01-01 23:33:00	2020-01-01 23:38:00
3	2	2020-01-01 23:43:00	2020-01-01 23:48:00
3	3	2020-01-01 23:53:00	2020-01-01 23:58:00