Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±í¹ÜÀí_3ÔÂ6ÈÕ

3ÔÂ6ÈÕ£º
¾Å¡¢±í¹ÜÀí£º
Ò»¡¢ÔÙ±í¹ÜÀíÖÐÐèҪѧϰµÄÄÚÈÝ£º
1¡¢  ´´½¨±í
2¡¢  ³£ÓõÄÊý¾ÝÀàÐÍ
3¡¢  ɾ³ý±í
4¡¢  ¸´ÖƱí
5¡¢  Ð޸ıí
6¡¢  ±íÖØÃüÃû
7¡¢  ½Ø¶Ï±í
8¡¢  ±íµÄÔ¼ÊøÌõ¼þ
¶þ¡¢´´½¨±í
³£¼û±íÓï·¨£º
´´½¨±íÓï·¨£º
CREATE TABLE ±íÃû
(
   &nb ......

Oracle±¨TNS 12518µÄ´íÎó

TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
  TNS-00530: Protocol adapter error
   32-bit Windows Error: 2: No such file or directory
½â¾ö·½·¨£º
      ÒòΪÎÒʹÓõÄÊÇÐéÄâ»ú£¬ËùÒÔÔÚIPÉÏĬÈϵÄ×Ô¶¯· ......

ORACLE 10 ѧϰ±Ê¼ÇÃüÁî µÚÒ»¿Î¡£(¸¶Ê×ê¿)

ORACLE 10 ѧϰ±Ê¼ÇÃüÁîµÚÒ»¿Î¡£
1.
sqlplus /nolog
connect /as sysdba
alter user scott account unlock;
alter user scott identified by manager;
2.
grant  select on dept to nmerp;
revoke select on dept to nmerp;
select * from scott.dept
create table abc(a varchar2(10),b char(10));
alter& ......

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

oracle°²È«
Óû§¹ÜÀí
DBAÊÚÓ費ͬÓû§²»Í¬È¨Àû£¬Ã¿¸öÓû§¿ÉÒÔÔÚÊÚȨ·¶Î§Äڻ£¬Èκγ¬Ô½È¨ÏÞ·¶Î§µÄ²Ù×÷¶¼ÊÓΪ·Ç·¨¡£
sysÓû§  ÍøÂç¹ÜÀíÔ± ÓµÓÐ×î¸ßȨÏÞ
conn sys/¿ÚÁî as sysdba;
systemÓû§ ±¾µØ¹ÜÀíÔ±
scottÓû§  Ê¾ÀýÊý¾Ý¿â
½¨Á¢Óû§£º£¨±ØÐëÓµÓÐdbaȨÏÞ£©
Create User Óû§Ãû Identified by ¿ÚÁî [E ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ