Wednesday 28 May 2014

Oracle Commands




  • To connect from client use sqlplus and type (username/password@hostname/servicename(sid))
  • To list all tables names for the logged in user (select table_name from user_tables;)
  • To select cashed maps (select name from user_sdo_cached_maps;)

  • java.lang.OutOfMemoryError: Java heap space; It means Map builder requires more heap memory to load spatial data. To solve it.: Open the command line and start the Map Builder application as follows. java -jar -Xmx1024M D:\mapbuilder.jar