Category: Database
-
error invoking target irman ioracle of makefile
If you run into the error “error invoking target irman ioracle of makefile” while trying to install Oracle Database, and the log shows a missing ljavavm12 library, you may need to copy the java library like so: cp ./u01/app/oracle/product/12.1.0/db_1/javavm/jdk/jdk6/lib/libjavavm12.a ./u01/app/oracle/product/12.1.0/db_1/lib/
-
Double the Oracle DB connections from JBoss you expect?
<no-tx-separate-pools/> – Pool Transactional and non-Transactional connections separately. Using this option will cause your total pool size to be twice max-pool-size because two actual pools will be created. Used to fix problems with Oracle.
-
MSSQL, jTDS, NVARCHAR and Slow Indexes
An application I’ve built is going into production soon. It’s the first application I’ve been involved with which will be using MSSQL server in production, I have some learning about MSSQL to do. After some research, I ended up using the jDTS JDBC driver instead of the Microsoft JDBC driver (which is feature incomplete and […]
-
Oracle Export (exp) and Initial Extent Size Issues
If you have a large database in Oracle, with a tablespace with say 2 gigabytes worth of data in it, and you then go in a delete a large number of rows from a large number of tables, and shrink it down to about 300 megabytes worth of data, and then you create an Oracle […]
-
An Easy Way to Drop All Tables in Your Tablespace in Oracle
If you need to drop all tables in the database with Oracle, here’s an easy way! run this command: select ‘drop table ‘, table_name, ‘cascade constraints;’ from user_tables; Then copy the output and run that as a sql script.
-
Oracle PL/SQL Loop to Update Fields with Periodic Commits
Have you ever had one of those moments where you’ve just completed importing 1.7 million user records from flat files into an normalized set of ATG Personalization tables, plus some custom tables, and you only then realize that the passwords from the old system, while in the compatible md5sum format, are all UPPERCASE, while ATG […]