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
¾¹ýÅŲé²âÊÔ£¬ÒѾÅųý·Ç·¨Í¼Ðε¼Ö´íÎóµÄ¿ÉÄÜÐÔ¡£
Íû¸÷λÅöµ½¹ý´ËÀàÎÊÌâµÄ¸ßÊÖ²»Áߴͽ̣¡ÏÈл¹ý£¡£¡{{
Ïà¹ØÎÊ´ð£º
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
Çë¸÷λ¸ßÊÖ°ïæ oracleºº×ÖתƴÒô
±ÈÈçÏÖÔÚÓиöÁÐ ÀïÃæµÄºº×ÖΪÄãºÃ ÎÒÏë²é³öÀ´µÄÊÇN ÇëÎʸ÷λ¸ßÊÖÈçºÎʵÏÖ ¸ø¸öÏêϸµÄ¿´¿´ лÁË
ÓÐÖªµÀµÄ¸æËßÒ»Éù ллÁË
ûÕÒµ½°¡ Äܸø·¢Ò»¸öÂð
ÄÄλ˧¸çÄܸøÏêϸµÄËµÒ ......
ÈçÏÂ2ÕÅ±í£º
table1:
node_id
parent_id
root_id
value
table2:
node_id
status
±í1´æ´¢ÁËÒ»¿ÃÊ÷£¬±í2´æ´¢Á˽ڵã״̬£¬ÎÊÌâÈçÏ£º
ÈçºÎÓÃSQLÓï¾ä»ñµÃ״̬statusΪ1µÄ½ÚµãµÄËùÓÐ×Ó½ÚµãÒÔ¼°ÆäÏÂ×ÓÊ÷ÖÐËùÓÐ½Ú ......
OracleÖÐSQLÓï¾äÖÐ
drop table ±íÃû cascadeconstraints
Óë
drop table ±íÃû cascadeconstraint
ÓÐʲôÇø±ð£¿
constraintºÍconstraintsÔÚoracleÖÐÊÇÒ»ÑùʹÓõÄ
¹Ù·½½¨ÒéʹÓÃconstraint
ÒýÓÃ
constraintºÍc ......
·þÎñÆ÷ϵͳÊÇxp,Êý¾Ý¿âoracle10g£¬web·þÎñÆ÷ÊÇtomcat£¬Á¬½ÓÊý¾Ý¿âʱ±¨Á¬½Ó´íÎó£¬ÈçÏÂËùʾ£ºThe Network Adapter could not establish the connectionÒì³££¬oracle·þÎñºÍ¼àÌýÒѾÆðÀ´ÁË£¨¶øÇÒ¶¼ÊÇÕýÈ·µÄ£©¡£Êý¾Ý¿âjar ......