During maintenance, I had to disable all constraints of a table. I knew that Oracle SQL Developer (I really like it even though it is a developer tool and not aimed at Database Administrators) had built-in functions to do this, but since I could only access the database machine via SSH, I had to do it in SQL*Plus.
Luckily, SQL Developer is quite transparent about the commands it uses and I could therefore easily see what is going on when you disable all constraints on a table using the GUI. So here it goes…
Read the rest of this entry
Because of its minimalistic interface and blazing speed, I am a big fan of Google Chrome. I am using the Developer channel version to get early access to the latest features such as the integrated PDF viewer or GPU acceleration. You can find more information on how to install this version here.
Another nice feature added with the latest version (8.0.552.0 dev as of this writing) is the “Instant” feature. It is basically Google Instant for your browser and greatly accelerates your browsing experience. This Instant feature loads the pages as you are typing in the URL bar of your browser. This means as soon as you see the correct page displayed (while typing), hit Enter and you are already there. Nice!
Read the rest of this entry
I keep this post mainly for my own reference, since I needed to do this multiple times already.
Edit the file sqldeveloper.conf in the bin/ directory of your SQL Developer installation and add the following lines to change the language to English:
AddVMOption -Duser.language=en
AddVMOption -Duser.country=US
Source