Monday, August 07, 2006

Oracle 10gAS install in a custom database

If you create a custom database (10.2.0.2) with the dbca, it will automatically install Oracle Spatial. If you use the command line or sqlplus, it doesn't. Spatial is required prior to running Repca. But, the pre-check doesn't catch that it isn't there. And the select statement given in the 10gAS documentation returns true when it isn't really there. So, be sure to put in prior to installing, otherwise you'll have to remove the metadata repository and start over. No fun.