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)
);

See also

Other Oracle error messages

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:51 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(51): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(66): id_of(Object(PDO), 'uri', '/notes/developm...') #2 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759473798, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/errors/ORA-14451_unsupported-feature-with-temporary-table(57): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51