Tag: Oracle
-
Oracle 12c RESTRICTED mode, disabled functionality
Today I learned a lot when our production database went in restricted mode. We had huge issues with our Oracle 12c database that was patched unsuccessfully. After the patch did not finish the database always restarted in RESTRICTED MODE, which means only admin / sys can connect to the database. All of our application could […]
-
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.