Finding Duplicate Records In a Database Table

Ideally business rules, that can be re-enforced at the database layer, should be implemented at the database layer to ensure that the integrity of the data can be relied on and does not lead to an unexpected behaviour from the application. Rules such as validation rules, e.g., which fields/columns cannot be null, etc. common sense … Continue reading Finding Duplicate Records In a Database Table


Import An Oracle Dump File

These are the steps I normally follow when restoring Oracle dump files for the purposes of my work. I prefer to logically keep the restored entities logically and physically separate through the use of tablespace and associated datafile(s) respectively. Create and assign the user to the earlier defined tablespace. If I want the created user … Continue reading Import An Oracle Dump File