Blog Archives

Duplicate Oracle Constraints

If you have ever used the Oracle import utility, your database has system generated constraint names (ex: SYS_C00641321), and you did not specify CONSTRAINTS=N during the import then chances are you have duplicate constraints for pretty much every constraint except

Tagged with: , , , , , , ,
Posted in Database Administration

Password Case Sensitivity in Oracle 11g

Oracle 11g now sets the password case sensitivity setting to TRUE by default. If you are running any application that connects to an earlier version of an Oracle database, chances are you are sending the connect string in all caps

Tagged with: , , , , ,
Posted in Database Administration

Running an Oracle Forms Applet on Windows 7

I was trying to run my application built in Oracle Forms and Reports on a new laptop with Windows 7. However, when running the Java forms applet, the applet’s graphics stayed frozen and I was not able to see my

Tagged with: , , , , , , , , ,
Posted in Database Administration, Tech

How to Modify Swap Size – Ubuntu 10.04

When installing Ubuntu, I was never asked about the desired size for my swap size. Oracle recommends to use at least 2GB of memory in order to create a database, let alone run it. With help from this excellent post

Tagged with: , , , , , ,
Posted in Tech

Error: Please make sure the Twitter account is public.