I recently heard about a bug related to identity columns and their underlying sequence : if the sequence is dropped, an
insert in the corresponding identity column would generate an error. Somehow it makes sense, but I wanted to check the behaviour in a recent Oracle Database version.
Fortunately, I have an “Always Free” 18.4 Autonomous Database in the Oracle Cloud, which is very convenient to run this kind of quick tests. The schema I am using is empty.
First, let’s create a simple table :Continue reading