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

Oracle ±íɾ³ý´óÁ¿Êý¾Ýºó²éѯ±äÂýÎÊÌâ


Oracle ±íɾ³ý´óÁ¿Êý¾Ýºó£¬¼´Ê¹±íÖÐÖ»Óм¸ÐмǼ£¬µ«ÓÃselect count(*) from table À´²éѯ·¢¾õ¶¼²»»áÂíÉϳöÀ´£¬Ô­ÒòÊǸñíµÄ¿Õ¼ä´óÁË£¬²éѯÆðÀ´ºÜÂý¡£½â¾öµÄ·½·¨ÊǰѸñíËùÕ¼Óõıí¿Õ¼äËõС£¬»òÕß˵Êͷűí¿Õ¼ä¡£
alter table XXXX move; ÕâÑù´¦Àíºó¾ÍÊÍ·ÅÁ˱í¿Õ¼äÁË¡£µ«ÊÇÊͷűí¿Õ¼äºó£¬±íµÄÐкÅrowid»á·¢Éú±ä»¯£¬¶ø»ùÓÚrowidµÄË÷ÒýÔò»á±ä³ÉÎÞЧ¡£Òò´Ë¸Ã²Ù×÷ºó±ØÐëÖØ½¨Ë÷Òý¡£·ñÔò»áÌáʾ“ORA-01502: Ë÷Òý'SMP.ITEMLOG_MID_IDX'»òÕâÀàË÷ÒýµÄ·ÖÇø´¦ÓÚ²»¿ÉÓÃ״̬” ¶øÖؽ¨Ë÷ÒýµÄ·½·¨µ±È»¿ÉÒÔÏÈdropµôÔÙcreate £¬µ«ÊÇÕâÑùÌ«Âé·³ÁË£¬ÓÃalter index XXX rebuild ÕâÑù×î¿ìÁË£¬²»»á¸Ä±äÔ­À´µÄË÷Òý½á¹¹¡£
 
À´Ô´£ºhttp://hi.baidu.com/bbz_dd_a/blog/item/1c962bf4b69666dff2d38588.html


Ïà¹ØÎĵµ£º

ÊÖ¹¤ÅäÖÃOracle 10G Enterprise Manage

ÊÖ¹¤ÅäÖÃOracle 10G Enterprise Manage
×î½üÔÚѧϰ°²×°Êý¾Ý¿âµÄʱºò£¬ÓÃÁ˶àÖÖ·½·¨´´½¨£¬Èçdbca´´½¨£¬ÊÖ¹¤´´½¨£¬ÓÃÄ£°æ´´½¨µÈµÈ£¬µ±ÓÃdbca´´½¨Êý¾Ý¿âµÄʱºò£¬Ã»ÓÐÑ¡Ôñ“ʹÓÃEnterprise ManagerÅäÖÃÊý¾Ý¿â”£¬Ôì³ÉºóÀ´ÏëÓÃem²»ÄÜʹÓ㬱ØÐèÓõ½ÊÖ¹¤ÅäÖÃem²ÅÄÜʹÓã¬ÏÂÃæ¾Í½éÉÜÁ½ÖÖµ¥ÊµÀý»·¾³ÊµÏÂemÅäÖÆ¡£
µÚÒ»ÖÖ ......

Oracle Êý¾Ý¿â ÊÂÎñ´¦Àí»ù±¾Ô­Àí

 
ÊÂÎñ´¦Àí£ºËùνµÄÊÂÎñ´¦Àí¾ÍÊDZ£Ö¤²Ù×÷µÄÍêÕûÐÔ£¬ËùÓвÙ×÷Ҫôͬʱ³É¹¦£¬ÒªÃ´Í¬Ê±Ê§°Ü¡£
Ô­ÀíÈçÏ£º
ÔÚOracleÿ¸öÁ¬½Óµ½Êý¾Ý¿âµÄ´°¿Ú£¬Á¬½ÓÖ®ºó½¨Á¢Ò»¸ösession¡£Ò»¸ösessionÀïÃæ¶ÔÊý¾ÝËù×öµÄÐ޸쬲»»áÁ¢¿Ì·´Ó¦ÔÚÊý¾Ý¿âµÄÕæÊµÊý¾ÝÖ®ÉÏ£¬ÊÇÔÊÐí»Ø¹öµÄ£¬µ±Ò»¸ösessionÌá½»ËùÓеIJÙ×÷ºó£¬Êý¾Ý²ÅÕæÕýµØ×ö³öÐ޸ġ£
& ......

oracleÃüÁî ÊÕ²Ø

  oracleÃüÁî ÊÕ²Ø
1. ORACLEÊý¾Ý¿âÆô¶¯Óë¹Ø±Õ
1.1 ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿â (ÊÖ¹¤)
1.1.1 sqlplusÁ¬½Ó
  #su - oracle
#sqlplus  /nolog
1.1.2 ´ò¿ªÊý¾Ý¿â
sql> connect sys/oracle as sysdba;
  sql> startup [nomount|mount]
µÈ´ýÊ®¼¸Ãë×óÓÒ£¬µ±¿´µ½
oracle instances started,
databa ......

¡¾×ª¡¿ OracleÖзÖÎö±íµÄ×÷ÓÃ

OracleÖзÖÎö±íµÄ×÷ÓÃ
http://diegoball.javaeye.com/blog/568009
ÎÄÕ·ÖÀà:Êý¾Ý¿â
1.·ÖÎö¸üбíµÄͳ¼ÆÐÅÏ¢,,ÓпÉÄܵ¼ÖÂÖ´Ðмƻ®¸Ä±ä..
2.ÒÔµÄanalyze table abc compute statistics;ÕâÌõΪÀý£¬Éú³ÉµÄͳ¼ÆÐÅÏ¢»á´æÔÚÓÚuser_tablesÕâ¸öÊÓͼ£¬²é¿´Ò»ÏÂselect * from user_tables where table_name='ABC';
¹Û²ìÒ»ÏÂNUM_RO ......

RAWÉ豸ÓëORACLEµÄÎÊ´ð


1£®Ê²Ã´½Ð×öÂãÉ豸£¿
¡¡¡¡ÂãÉ豸£¬Ò²½ÐÂã·ÖÇø£¨Ô­Ê¼·ÖÇø£©£¬ÊÇÒ»ÖÖûÓо­¹ý¸ñʽ»¯£¬²»±»Unixͨ¹ýÎļþϵͳÀ´¶ÁÈ¡µÄÌØÊâ×Ö·ûÉ豸¡£ËüÓÉÓ¦ÓóÌÐò¸ºÔð¶ÔËü½øÐжÁд²Ù×÷¡£²»¾­¹ýÎļþϵͳµÄ»º³å¡£
2£®ÈçºÎ±æ±ðÂãÉ豸£¿
¡¡¡¡ÔÚUnixµÄ/dev Ŀ¼Ï£¬ÓÐÐí¶àÎļþ£¬ÆäÖÐÓÐÁ½¸ö´óÀࣺ×Ö·ûÉ豸ÎļþºÍ¿éÉ豸Îļþ¡£
¡¡¡¡×Ö·ûÉè±¸Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ