Description: Unique constraint (string.string) violated
- A DML command like UPDATE, INSERT attempt to insert duplicated keys
- A trigger trying to insert/update duplicated keys
- Abort update/insert the key
- Turn off/modify the trigger
- Remove the unique constraint
To install Ubuntu/Lubuntu or many Linux distros from USB stick, in this post, I will show you how to create bootable Ubuntu USB from ISO file.
Step 1: Download the ISO file
For Ubuntu server, you can go to https://www.ubuntu.com/download/server and download desired version of Ubuntu as an ISO file … Read the rest “How to create bootable Ubuntu USB from ISO file in Windows”
Some of database datafiles are damaged or corrupted or moved to another position without modifying datafile name or datafiles are missing, … and now we need to startup the Oracle database ignoring missing datafiles.
In this case, assume that we miss
We’ll got some console like this:
… Read the rest “How to start Oracle database ignore missing datafile(s)”
In this post, I will show you all commands to start and stop Oracle databases. This is the basics but essentials while working with Oracle.
Login into database server, switch to oracle user and start sqlplus tool
su - oracle
sqlplus / as sysdba
Everytime you … Read the rest “How to start & stop Oracle databases (startup & shutdown)”