Re: On the premises Oracle 21c download

> Does Oracle 21c allow indexing local temporary tables?

No it doesn't.

create private temporary table ora$ptt_demo ( id integer unique
, description varchar2(30) )
on commit preserve definition;

ORA-14451: unsupported feature with temporary table

Same error if I create the table first then try to add an index.

William

On 20 Jun 2021, at 20:46, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

Hi!

I am fishing for rumors and gossip. Does anyone have any half way reliable information about the availability of Oracle 21c for download? The client has been on OTN for months now. Any idea as to when the full Oracle 21c download might become available? Oracle 20 is obviously skipped. Does Oracle 21c allow indexing local temporary tables?

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l