Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table all_data
(
 kind varchar2(10)
,time_period date
,amount number
)
insert into all_data
values('peter',sysdate,1000)
1 rows affected

insert into all_data
values('peter',sysdate+1,2000)
1 rows affected

insert into all_data
values('maria',sysdate,1000)
1 rows affected

insert into all_data
values('eric',sysdate,1000)
1 rows affected

declare
  type array_t is table of varchar2(10);
  array array_t := array_t();
  lo_stmt varchar2(2000);
begin
  select distinct kind
    bulk collect into array
    from all_data;
  
  for i in 1..array.count loop
    dbms_output.put_line(array(i));
    lo_stmt :=
    'create table '||array(i)||'_data '||
    'as '||
    'select kind,time_period,amount '||
    '  from all_data '||
    ' where kind = '''||array(i)||'''';
    dbms_output.put_line(lo_stmt);
    execute immediate lo_stmt;
  end loop;
end;
/
1 rows affected

dbms_output:
peter
create table peter_data as select kind,time_period,amount   from all_data  where kind = 'peter'
maria
create table maria_data as select kind,time_period,amount   from all_data  where kind = 'maria'
eric
create table eric_data as select kind,time_period,amount   from all_data  where kind = 'eric'

select * from Peter_data


KIND
TIME_PERIOD
AMOUNT


peter
21-SEP-22
1000

peter
22-SEP-22
2000


select * from maria_data


KIND
TIME_PERIOD
AMOUNT


maria
21-SEP-22
1000


select * from eric_data


KIND
TIME_PERIOD
AMOUNT


eric
21-SEP-22
1000