Quick Tip: Getting EXP to Shut Up

Today I found out that what I thought was standard output from Oracle’s export utility, exp, is actually error output. In trying to get exp to run quietly in the background while I continue to use the shell, I tried running “exp silent=y &” and I still got all the wonderful exporting this table and exporting that object. On a +160GB database, that takes a while and is a bit annoying. So, I tried running […]

H2 support added to AED project on RiaForge

I’m in the final stages of adding support for H2 databases to the OracleAED project hosted on RiaForge. This is really quite exciting to me because the project is growing beyond support for Oracle databases. The H2 database is also exciting in it’s own right. I’ve found it to be easy to use and rich with features that young database engines just don’t have like drop column and the data dictionary (INFORMATION_SCHEMA) made adding H2 […]

H2 and Database GUI for Linux

So, as I mentioned before, I have a VirtualBox setup with H2 and Open BlueDragon. I have been very impressed with H2 and the H2 web console. However, I was looking for a database gui to see what I have in my head on the screen. I tried Oracle SQLDeveloper since it’s my home court, but I had trouble getting the JDBC driver for H2 to work inside SQLDev. Enter DbVisualizer [http://www.dbvis.com/]. DbVis, the free […]