Key Preserved Table Asktom

Key Preserved Table Asktom

  6:05 AM    cemer

---

Not really, but we're doing some asktom changes soon to increase the metadata associated with each question, (since it is a key preserved table),. Ora-01779: error oracle 10.2.0.1.0 cannot modify a column which maps to a non key-preserved table". there is nice explanation of this error on asktom:. However, different sql statements check for key perservation by different mechanisms. note: originally a comment on asktom . probably the best statement i've seen on "key preservation" in the documentation is this one: the key-preserving property of a table does not depend on the actual data in the table. it is, rather, a property of its schema..

But now my friend want another column to store counts, to improve the performance of his report that takes too long to do the counts. i used the following sql to calculate the counts in an alias table and then update the column in the base table, but i get this error: cannot modify a column which maps to a non key-preserved table. Ora-01779 cannot modify a column which maps to a to a non key-preserved table topic of key-preserved tables - https://asktom.oracle.com/pls/apex. 1 update 2 (select src.before src_before 3 , tgt.before tgt_before 4 from test1 src 5 , test1 tgt 6 where src.id1 = tgt.id1 7 and src.id2+1 = tgt.id2 8 and src.id2 = 1 9 ) 10* set tgt_before = src_before sql> / set tgt_before = src_before * error at line 10: ora-01779: cannot modify a column which maps to a non key-preserved table.

key preserved table asktom

visit link reference