Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......

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

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