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

oracleµÄ±íµÄÖÖÀà

±íÀàÐÍ£º
1¶Ñ×éÖ¯±í£¨heap organized table£©£ºÕâЩ¾ÍÊÇ“ÆÕͨ”µÄ±ê×¼Êý¾Ý¿â±í¡£Êý¾ÝÒԶѵķ½Ê½¹ÜÀí¡£¶Ñ£¨heap£©ÊÇÒ»×é¿Õ¼ä£¬ÒÔÒ»ÖÖÓÐЩËæ»úµÄ·½Ê½Ê¹Óá£
2Ë÷Òý×éÖ¯±í£¨index organized table£©£ºÕâЩ±í°´Ë÷Òý½á¹¹´æ´¢¡£Õâ¾ÍÇ¿ÖÆÒªÇóÐб¾ÉíÓÐijÖÖÎïÀí˳Ðò¡£Ë÷Òý×éÖ¯±íIOTÖУ¬Êý¾ÝÒª¸ù¾ÝÖ÷¼üÓÐÐòµØ´æ´¢¡£
3Ë÷Òý¾Û´Ø±í£¨index clustered table£©£º¾Û´Ø£¨cluster£©ÊÇÖ¸Ò»¸ö»ò¶à¸ö±í×é³ÉµÄ×飬ÕâЩ±íÎïÀíµØ´æ´¢ÔÚÏàͬµÄÊý¾Ý¿â¿éÉÏ£¬ÓÐÏàͬ¾Û´Ø¼üÖµµÄËùÓÐÐлáÏàÁÚµØÎïÀí´æ´¢¡£
    ÕâÖֽṹ¿ÉÒÔʵÏÖÁ½¸öÄ¿±ê¡£
    Ê×ÏÈ£¬¶à¸ö±í¿ÉÒÔÎïÀíµØ´æ´¢ÔÚÒ»Æð¡£Ò»°ã¶øÑÔ£¬Äã¿ÉÄÜÈÏΪһ¸ö±íµÄÊý¾Ý¾ÍÔÚÒ»¸öÊý¾Ý¿â¿éÉÏ£¬µ«ÊǶÔÓÚ¾Û´Ø±í£¬¿ÉÄܰѶà¸ö±íµÄÊý¾Ý´æ´¢ÔÚͬһ¸ö¿éÉÏ¡£
    Æä´Î£¬°üº¬Ïàͬ¾Û´Ø¼üÖµ£¨ÈçDEPTNO=10£©µÄËùÓÐÊý¾Ý»áÎïÀíµØ´æ´¢ÔÚÒ»Æð¡£ÕâЩÊý¾Ý°´¾Û´Ø¼üÖµ“¾Û´Ø”ÔÚÒ»Æ𡣾۴ؼüʹÓÃB*Ê÷Ë÷Òý½¨Á¢¡£
4É¢ÁÐ¾Û´Ø±í£¨hash clustered table£©£ºÕâЩ±íÀàËÆÓÚ¾Û´Ø±í£¬µ«ÊDz»Ê¹ÓÃB*Ê÷Ë÷Òý¾Û´Ø¼üÀ´¶¨Î»Êý¾Ý£¬É¢Áо۴ؽ«¼üÉ¢Áе½¾Û´ØÉÏ£¬´Ó¶øÕÒµ½Êý¾ÝÓ¦¸ÃÔÚÄĸöÊý¾Ý¿â¿éÉÏ¡£
    ÔÚÉ¢Áо۴ØÖУ¬Êý¾Ý¾ÍÊÇË÷Òý£¨ÕâÊÇÒþÓ÷µÄ˵·¨£©¡£Èç¹ûÐèҪƵ·±µØͨ¹ý¼üµÄÏàµÈÐԱȽÏÀ´¶ÁÈ¡Êý¾Ý£¬É¢Áо۴رí¾ÍºÜÊÊÓá£
5ÓÐÐòÉ¢ÁÐ¾Û´Ø±í£¨sorted hash clustered table£©£ºÕâÖÖ±íÀàÐÍÊÇOracle 10gÖÐÐÂÔöµÄ£¬Ëü½áºÏÁËÉ¢Áо۴رíµÄijЩ·½Ã棬ͬʱ¼æÓÐIOTµÄһЩ·½Ãæ¡£
    ÄãµÄÐа´Ä³¸ö¼üÖµ£¨ÈçCUSTOMER_ID£©É¢ÁУ¬¶øÓë¸Ã¼üÏà¹ØµÄһϵÁмǼÒÔijÖÖÓÐÐò˳Ðòµ½´ï£¨Òò´ËÕâЩ¼Ç¼ÊÇ»ùÓÚʱ¼ä´ÁµÄ¼Ç¼£©£¬²¢°´ÕâÖÖÓÐÐò˳Ðò´¦Àí¡£
    ÀýÈ磬¿Í»§ÔÚÄãµÄ¶©µ¥ÊäÈëϵͳÖÐ϶©µ¥£¬ÕâЩ¶©µ¥»á°´ÏȽøÏȳö£¨first in, first out, FIFO£©µÄ·½Ê½»ñÈ¡ºÍ´¦Àí¡£ÔÚÕâÑùÒ»¸öϵͳÖУ¬ÓÐÐòÉ¢Áо۴ؾÍÊÇÊÊÓõÄÊý¾Ý½á¹¹¡£
6ǶÌ×±í£¨nested table£©£ºÇ¶Ì×±íÊÇOracle¶ÔÏó¹ØϵÀ©Õ¹µÄÒ»²¿·Ö¡£ËüÃÇʵ¼ÊÉϾÍÊÇϵͳÉú³ÉºÍά»¤µÄ¸¸/×Ó¹ØϵÖеÄ×Ó±í¡£
    ǶÌ×±íÓë×Ó±íµÄÖ÷ÒªÇø±ðÊÇ£ºÇ¶Ì×±í²»Ïñ×Ó±í£¨ÈçEMP£©ÄÇÑùÊÇ“¶ÀÁ¢”±í¡£
7ÁÙʱ±í£¨temporary table£©£ºÕâЩ±í´æ´¢µÄÊÇÊÂÎñÆÚ¼ä»ò»á»°ÆÚ¼äµÄ“²Ý¸å”Êý¾Ý¡£
    ÁÙʱ±íÒª¸ù¾ÝÐèÒª´Óµ±Ç°Óû§µÄÁÙʱ±í¿Õ¼ä·ÖÅäÁÙʱÇø¶Î¡£Ã¿¸ö»á»°Ö»ÄÜ¿´µ½Õâ¸ö»á»°·ÖÅäµÄÇø¶Î£»Ëü´Ó²»»á¿´µ½ÆäËûÈκλá»


Ïà¹ØÎĵµ£º

oracle database link

Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈ
ÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£ 
1¡¢   Á´½Ó×Ö·û´®¼´·þÎñÃû£¬Ê×ÏÈÔÚ±¾µØÅäÖÃÒ»¸ö·þÎñÃû£¬µØÖ·Ö¸ÏòÔ¶³ÌµÄÊý¾Ý¿âµØÖ·£¬·þÎñÃûȡΪ½«À´ÄãҪʹÓõÄÊý¾Ý¿âÁ´Ãû£º
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¬
½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁî£ ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç12


¹ØϵÐÍÊý¾Ý¿âÀíÂÛÖÐ×Ö¶ÎÖµ±ØÐëÊǵ¥Öµ£¬¶øoracleÖÐÔÊÐíÔÚÒ»¸ö×Ö¶ÎÖд洢һ¸ö±íµÄÄÚÈÝ¡£
È磺Ա¹¤±íÖеÄÍâ¼ü ²¿ÃűàºÅ£¬oracleÖÐÕâ¸ö×ֶοÉÒÔ´æ·Å²¿ÃŵļǼ¶ø²¢²»ÊÇÒ»¸öÍâ¼ü£¬ÕâÑù²éѯʱºòµÄЧÂÊ»áÌá¸ß¡£
¿É±äÊý×飺
´´½¨´øÓпɱäÊý×éµÄ±í
´´½¨¿É±äÊý×é»ùÀàÐÍ
create or replace type »ùÀàÐÍÃû as object(×Ö¶ÎÇåµ¥); ......

oracleÁ¬½ÓÔ¶³ÌÊý¾Ý¿â

D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN
6¡¢ÐÞ¸Äoracle°²×°Â·¾¶ÏÂD:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.oraµÄtnsnames.oraÎļþ£¬Ìí¼Ó
XXX =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.42 ......

Oracle ÈçºÎ¶¨Òå×Ô¶¯ÔöÁ¿autocreamentµÄÖ÷¼üID?

MySQLµÄID·Ç³£·½±ã¶¨Ò壬ֻҪָ¶¨Æä×ֶεÄ×Ô¶¯ÔöÁ¿ÊôÐÔ¼´¿É¡£
µ«ÊÇOracle²»ÐУ¬ÐèÒª¶¨ÒåsequenceºÍtriggedr£¬µ±È»trigger¿ÉÒÔ²»¶¨Ò壬µ«ÊDz»·½±ã¡£
±í¶¨ÒåÈçÏ£º
CREATE TABLE GAME
(
  ID           
INTEGER      ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ