I insert a row into a table, roll it back, yet somehow I’ve created a new object in my database!
select count(*) from user_objects; COUNT(*) ---------- 2 insert into a_table values ('that create', 1, 'new object'); rollback; select count(*) from user_objects; COUNT(*) ---------- 3
There’s no triggers or other “trickery” involved – the code above is a copy-paste in a database where I have the only session.
How did this happen? Put your answers in the comments!
If you’d like to get more posts on using and designing Oracle databases, enter your details the form below to receive future updates.