Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ

Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-06553: PLS-123: program too
large Thu Sep 17 04:27:06 2009 Trace dumping is performing
id=[cdmp_20090917042706]

 

³ö´íÓï¾äΪ:

SELECT distinct a.g3e_fid,b.bureau_id from m_needed_dzk a,s_grid_p b
  WHERE b.g3e_fid=1001218319 and
  SDO_relate(a.g3e_geometry,b.g3e_geometry,'mask=INSIDE
querytype=window') = 'TRUE'

(ÿ´Î³ö´íµÄg3e_fid²»Í¬)

 

Êý¾Ý¿â»·¾³Îª9.2.0.8

¾­¹ýÅŲé²âÊÔ£¬ÒѾ­Åųý·Ç·¨Í¼Ðε¼Ö´íÎóµÄ¿ÉÄÜÐÔ¡£

 

Íû¸÷λÅöµ½¹ý´ËÀàÎÊÌâµÄ¸ßÊÖ²»Áߴͽ̣¡ÏÈл¹ý£¡£¡{{


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

oracle ÊÔͼÎÊÌ⣬Çë¸ßÊÖ°ï棬ÔÚÏßµÈ.....

ÎÊÌâÃèÊö£º
1¡¢¼ÙÉèÓбí
t1±í£¬°üº¬ËÄÁÐ
 s1 a b c
 1 a a a
 2 b b b 
.........
t2±í£¬°üº¬2ÁÐ
s2 ff
1 77
2 88
............
ÈçºÎÉú³ÉÕâÑùµÄºÏ²¢Ê ......

ÎÒʹÓÃmyeclipse6.0Ïòoracle 10gÖÐдÊý¾ÝÎÞ·¨Ð´½øÈ¥

[color=#FF0000][/color]ÒÔÏÂÊÇÎÒµÄservlet´úÂë[color=#FF0000][/color]package JDBCExample1.demo1;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ