Search notes:

ORA-14451: unsupported feature with temporary table

Trying to create a private temporary table with a not null, unique or primary key constraint, or a check constraint throws the error message ORA-14451: unsupported feature with temporary table:

create private temporary table ora$ptt_x (
   id  integer not null,
   txt varchar2(10)
);

create private temporary table ora$ptt_x (
   id  integer unique,
   txt varchar2(10)
);

create private temporary table ora$ptt_x (
   id  integer primary key,
   txt varchar2(10)
);

However, this one is ok:

create private temporary table ora$ptt_x (
   id  integer,
   txt varchar2(10)
);

ORA-14451: unsupported feature with temporary table

See also