Thursday, July 14, 2011

Size of geometry in your postgis table

Here's how to find the size of geometry column in a table:

SELECT pg_size_pretty(CAST(SUM(ST_Mem_Size(geometry_column)) As bigint) ) as totgeomsum
FROM yourtable;

Wednesday, July 13, 2011

Install oracle client and sql loader on ubuntu 1104

  1. Install the client and verify that it is working
  2. Download the 11g beta version of the database. Take the RPM of course and not .exe ;)
  3. Extract the rpm, then cpio and then contents of the cpio (I know, how insane is that?).
  4. copy the u01/app/oracle/product/11.2.0/xe/bin/sqlldr to /usr/lib/oracle/11.2/client64/bin/ (or /usr/lib/oracle/11.2/client/bin/ depending on your arch)
  5. copy the u01/app/oracle/product/11.2.0/xe/rdbms/mesg to /usr/lib/oracle/11.2/client64/rdbms/mesg/