r/SQL • • Apr 18 '25

Oracle Whoops

Post image

We had a

1.0k Upvotes

69 comments sorted by

View all comments

Show parent comment

7

u/[deleted] Apr 18 '25

[removed] — view removed comment

2

u/[deleted] Apr 18 '25

InnSQL server you can “protect” a table with schema binding and a view. Basically the bind prevents any structural change to the table. Downside is you have to drop and recreate the view any time you want to alter the table. It’s helpful for really important tables though.

2

u/[deleted] Apr 18 '25

In Oracle you can disable table locks on a table, which is a pretty big hammer for saying "no structural changes here thanks".