Search notes:

ORA-32638: Non unique addressing in MODEL dimensions

creating a test table
create table tq84_tab (
   dim_1  number,
   dim_2  varchar2(10),
   val_1  number,
   val_2  number
);
Insert some values for which the combination of dim_1 and dim_2 is unique:
insert into tq84_tab values (1, 'aaa', 17,  9);
insert into tq84_tab values (1, 'bbb', 12,  7);
insert into tq84_tab values (1, 'ccc',  4, 12);
insert into tq84_tab values (2, 'aaa',  2,  6);
Inserting this record will cause ORA-32638: Non unique addressing in MODEL dimensions error with following select statement because values of specified dimensions are not unique:
insert into tq84_tab values (1, 'bbb', 12,  7);
Select statement to try model clause
select * from tq84_tab
model
   dimension by (dim_1, dim_2)
   measures     (val_1, val_2)
   rules        (            )
;
Cleaning up:
drop table tq84_tab;

See also

The MODEL clause
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:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759406443, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/errors/ORA-32638_Non-unique-addressing-in-MODEL-dimension(69): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78