create table as with, disconnected the session in Oracle 11.2.0.4

Hi everybody,

I'm facing an issue after upgrading our DW database (4.5 TB) from 10.2.0.5 to 11.2.0.4

The colleagues in development has reported this Problem:

--the next Program script is failed:

create table ma_karten_ses_tmp

as

with ma_karten_statusfolge

as

(

    select p.karten_nr alt_karten_nr, p.param1 status, p.von_datum, p.bis_datum,

           lead(p.param1) over (partition by p.karten_nr order by p.von_datum) next_status

      from ma_karten_param p

     where p.param_art = 'AKTION_CD'

       and p.von_datum >= to_date('20141101', 'yyyymmdd')

)

select alt_karten_nr

  from ma_karten_statusfolge