Çë½Ì¹ØÓÚoracleË÷ÒýµÄ¼¸¸öÎÊÌâ
ÎÒÏÖÔÚÓõÄÊÇoracle 9i 1.Ò»¸ö±í½¨Á¢¶àÉÙ¸öË÷Òý±È½ÏºÏÊÊ£¿±ÈÈç˵²»´óÓÚ5¸ö 2.ÁªºÏË÷Òý±Èµ¥Ë÷ÒýµÄЧÂʸßô£¿ 3.compress Õâ¸öѹËõ £¬ÄÜÆðµ½Ê²Ã´×÷Óã¿ 4.ÉÏÍøÉϲé×ÊÁÏʱ£¬¶¼ËµoracleʹÓÃÁªºÏË÷ÒýÐèҪǰµ¼ÁУ¬Õâ¸öºÍ°æ±¾ÓйØÏµÂ𣿠5.Èç¹û²»ÐèҪǰµ¼Áеϰ£¬reverse Õâ¸ö·´×ª ÓÖÆðµ½Ê²Ã´×÷ÓÃÄØ£¿ ÎÒ×Ô¼ºÓÃÒ»¸öµ¥±í¶ÔË÷Òý½øÐÐÁËÒ»¸ö¼òµ¥µÄ²âÊÔ£¬½á¹ûÈçÏ£º 1¡¢¶à¸öµ¥Ë÷Òý Ò»ÆðʹÓà »á·Ö±ðµ÷Óø÷×ÔµÄË÷Òý 2¡¢µ¥Ë÷ÒýºÍÎÞË÷Òý×Ö¶Î »áʹÓõ¥Ë÷Òý 3¡¢ÁªºÏË÷ÒýºÍÎÞË÷Òý×Ö¶Î £¨²»³öÏÖµ¥Ë÷Òý×ֶΣ© »áʹÓÃÁªºÏË÷Òý £¨ÁªºÏË÷Òý×Ö¶Î ²»ÓÃÇ¿µ÷˳Ðò £¬Ò²¾ÍÊDz»ÐèҪǰµ¼ÁУ¬ÎÞË÷Òý×ֶλ¹¿ÉÒÔÔÚÁªºÏË÷Òý×Ö¶ÎÖ®¼ä£© 4¡¢µ¥Ë÷ÒýºÍÁªºÏË÷ÒýÒ»ÆðʹÓà 1£©Èç¹ûÁªºÏË÷ÒýÖÐ×Ö¶ÎÈ«²¿³öÏÖ ÔòʹÓÃÁªºÏË÷Òý £¨ÁªºÏË÷Òý×Ö¶Î ²»ÓÃÇ¿µ÷˳Ðò£© 2£©Èç¹ûÁªºÏË÷ÒýÖÐÖ»Óв¿·Ö×ֶγöÏÖ Ôò»áʹÓõ¥Ë÷Òý 5¡¢ÁªºÏË÷ÒýºÍÁªºÏË÷ÒýÒ»ÆðʹÓà 1£©Èç¹ûÆäÖÐÒ»¸öÁªºÏË÷ÒýÖÐÖ»Óв¿·Ö×ֶγöÏÖ Ôò»áʹÓÃÁíÒ»¸öÁªºÏË÷Òý 2£©Èç¹ûÁ½¸ö¶¼ÍêȫʹÓ㬻ò¶¼²»ÍêȫʹÓà »áÑ¡ÔñÆäÖÐÒ»¸öʹÓ㨲»³öÏÖµ¥Ë÷Òý×ֶΣ¬Èç¹û³öÏÖ£¬»áʹÓü䵥Ë÷Òý£©£¬ ¾ßÌåÔõôѡÔñµÄ£¬²»Çå³þ£¿£¿£¿£¿ ˵µÄ²»×¨Òµ ´ó¼Ò´ÕºÏ¿´£¬ Ï£ÍûÖ¸µãСµÜһϡ£ ÏÈллÀ²¡£
ÎÞÈËÎʽòѽ¡£ ×Ô¼º¶¥Ò»Ï¡£ ¸øLZ¶¥ÆðÀ´ÏÈ£¬Ï£ÍûÄãµÄÎÊÌâÄܱ»½â¾ö ßÀ¡£¡£ ÈËÆø²»ºÃѽ¡£ ÐÖµÜÃǸ÷Ê㼺¼ûѽ¡£ÒýÓà ÎÒÏÖÔÚÓõÄÊÇoracle 9i 1.Ò»¸ö±í½¨Á¢¶àÉÙ¸öË÷Òý±È½ÏºÏÊÊ£¿±ÈÈç˵²»´óÓÚ5¸ö Õâ¸öûÓж¨ÂÛ£
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
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 / ......
SQL code: declare v_deptno number(2); v_dname varchar2(14); begin dbms_output.put_line('ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû:'); v_deptno:=&deptno; v_dname:='&dname'; insert into dept01(deptno,dnam ......