SQL

Disabling Constraints with a Stored Procedure in Oracle

Sometimes you need to disable constraints on a Oracle Database. Why might this be? Well image the situation that you are exporting data into an intermediate schema, you only want to import data from a certain date range and due to this you have only a subset of the records. You need this subset for analysis but you don't care about referential integrity - in fact if it is on then constraints will be violated.
Read more

Using imp or exp as a SYSDBA

One of the things that I regularly forget is the syntax for running imp or exp for Oracle and specifying a SYSDBA user. As a quick hint, here's the syntax: imp '"sys/pass@TNS as sysdba"' FILE=file.exp An easy thing to forget!