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

oracleÖÐÌí¼ÓºÍɾ³ýÊý¾Ýʱ³ö´í - Oracle / »ù´¡ºÍ¹ÜÀí

1.Ìí¼Óʱ³ö´í:
  ´´½¨Ò»¸öÁÙʱ±í£¬²åÈë1000wÌõ¼Ç¼ʱ£¬±¨´í£ºora-30009: connect by ²Ù×÷ÄÚ´æ²»×ã
  ¸Ä³ÉÖ»²åÈë500wÐÐʱ¾Íû´íÁË¡£
   
  ¹ÊÇó¸ßÊÖÃǰïæ ½â¾öora-30009: connect by ²Ù×÷ÄÚ´æ²»×ãµÄÎÊÌâ

2.ɾ³ýÊý¾Ýʱ±¨´í:
  ÔÚʹÓÃforall...delete...ÅúÁ¿É¾³ýʱ³ö´í
  ´íÎó´úÂëÈçÏÂ:
  SQL code:

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: ÔÚ "SYS.DBMS_OUTPUT", line 32
ORA-06512: ÔÚ "SYS.DBMS_OUTPUT", line 97
ORA-06512: ÔÚ "SYS.DBMS_OUTPUT", line 112
ORA-06512: ÔÚ line 15



  Ï£Íû´ó¼Ò°ïæ½â¾öÒÔÉÏÁ½¸öÎÊÌ⣬²»Éõ¸Ð¼¤£¡


 
ÄÚ´æÏÞÖÆÁË£¬Çë¼ì²é

½«outputµÄbuffer size µ÷´ó

ÒýÓÃ
ÄÚ´æÏÞÖÆÁË£¬Çë¼ì²é

  ÔõÑù½â¾ö°¡£¡ À´¸ö¸ßÊÖ£¡

2.ɾ³ýÊý¾Ýʱ±¨´í:
  ÔÚʹÓÃforall...delete...ÅúÁ¿É¾³ýʱ³ö´í
  ´íÎó´úÂëÈçÏÂ:
----------------------------------
DBMS_OUTPUT.ENABLE(1000000); -- ¼Óµ½×ã¹»´óΪֹ

ÎÒ¾õµÃÄ㻹ÊÇ·ÖÅúÌύһϰÉ

»¥Ïàѧϰ
SQL> exec dbms_output.enable(100000);

PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
ÊÔÊÔ¿´

ora-30009: connect by ²Ù×÷ÄÚ´æ²»×ã
  Õâ¸öÎÊÌâÔõÑù½â¾öÄØ£¿

ÏÖÔÚ»¹Ã»Óöµ½¹ýÕâÑùµÄÎÊÌâ
ÏȼÇÏ¡£

½â¾ö


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......

·ÖÏí×Ô¼ºµÄOracleÅäÖùý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ