Tag: sequences
-
Oracle: Enable/Disable all constraints in schema at once
Here are the snippets for enabling and disabling all constraints in an oracle schema. This is useful when you create a new schema and then fill it up with the data from other databases. For whatever reason you will need this be careful to only enable primary keys at first, otherwise all foreign key validation […]
-
Oracle: Update all sequences for tables for current user
Below is procedure that updates all table sequences to match the max ID currently in a table. Useful when there is a mismatch of values.