Creating single table having multiple schema data

Hi All,

I am trying to create single sql statement where I am trying to re call all catalog database schema and give output as one.

But the same is failing with multiple errors.

Can anyone help here to integrate the same.

-- Add table logic as a separate transaction

declare cnt number;

begin

  -- check if the temp table exists, otherwise, create one

  select count(*) into cnt from all_tables where table_name = 'PRIVS_TBL' and owner = 'DBADMIN';

  if cnt = 1 then

    EXECUTE IMMEDIATE ('drop table dbadmin.privs_tbl');

  end if;

  EXECUTE IMMEDIATE ('CREATE TABLE privs_tbl

            (

             session_key VARCHAR2(250),