#ORA-14451: unsupported feature with temporary table

[sandeep2363]

Private Temporary Tables in Oracle 18c

Private Temporary Tables in Oracle 18c

Example of using Private Temporary Tables in Oracle 18c Oracle already has a Global temporary table, but a Private temporary table is placed in the memory area but a Global temporary table is in Disk. You can create a private temporary table with a default prefix “ORA$PTT_” which is defined in the parameter private_temp_table_prefix. Global temp table available in all sessions but Private temp…