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

oracle Æô¶¯¹ÜÀíÆ÷

 emctl start dbconsole ÊÇ10gµÄÆô¶¯console·þÎñµÄÃüÁî
½«OEM·þÎñÍ£Ö¹emctl stop dbconsole
emctl start dbconsoleÆô¶¯EM console·þÎñ£¬Ê¹ÓÃǰÐèÒªÏÈÉèÖÃORACLE_SID»·¾³±äÁ¿
emctl stop dbconsoleÍ£Ö¹EM console·þÎñ£¬Ê¹ÓÃǰÐèÒªÏÈÉèÖÃORACLE_SID»·¾³±äÁ¿
¹Ø±ÕÊý¾Ý¿âºóÓ¦¸ÃÊ×ÏÈÓÃsysdbaµÇ½,ÕâÑù¾Í½øÈëÁËsysģʽ.  
   
  SQL>connect   system/system@oradb   as   sysdba;  
   
  --¼ÓÔØÊµÀý,²»´ò¿ªÊý¾Ý¿â  
   
  SQL>startup   open;
Oracle Êý¾Ý¿âµÄ¼¸¸ö¹Ø±Õ·½·¨
¡¡¡¡¶ÔÓÚORACLEÀ´½²£¬¹Ø±ÕµÄ·½·¨ÓÐÈý¸ö:
¡¡¡¡ÔÚSVRMGRLÏ¿ÉÒÔÊäÈëÈçÏÂÓï¾ä£¬¾Í¿É¹Ø±ÕÊý¾Ý¿â£¬µ«Ã¿¸öÓï¾ä¶¼ÓÐ×Ô¼ºµÄ×÷Óã¬ÓеÄÓï¾ä»¹±ØÐëÉ÷ÖØÊ¹ÓÃ
¡¡¡¡1¡¢shutdown normal (´Ó×ÖÃæ¾Í¿ÉÀí½âÕâÊÇÒ»¸öÓÃÕý³£µÄ·½Ê½À´¹Ø±ÕÊý¾Ý¿â¡£)
¡¡¡¡2¡¢shutdown immediate (Á¢¼´·½Ê½¹Ø±ÕÊý¾Ý¿â¡£)
¡¡¡¡µ±Ö´ÐÐshutdown immediateʱ£¬Êý¾Ý¿â²¢²»Á¢¼´¹Ø±Õ£¬¶øÊÇÔÚOracleÖ´ÐÐÍêÄÚ²¿µÄ±ØÒªµÄ¹¤×÷ºó²Å¹Ø±Õ£¬shutdown immediate¿ÉÒÔÍê³Éshutdown²»ÄܶÔÊý¾Ý¿â¹Ø±ÕµÄ²Ù×÷¡£½¨ÒéDBAÃdz£Óô˷½·¨¹Ø±ÕÊý¾Ý¿â
¡¡¡¡3¡¢shutdown abort (Ö±½Ó¹Ø±ÕÊý¾Ý¿â)
¡¡¡¡Õâ¸öÍ£Ö¹µÄ·½·¨²»ÍƼö£¬ÒòΪ¶ÔÓÚÕýÔÚ·ÃÎÊÊý¾Ý¿âµÄ»á»°»á±»Í»È»ÖÕÖ¹£¬¿ÉÄÜ»áÔì³ÉÊý¾Ý¿âµÄÊý¾Ý¶ªÊ§£¬²¢ÇÒÈç¹ûÊý¾Ý¿âÖÐÓдóÁ¿²Ù×÷ÕýÔÚÖ´ÐУ¬ÕâʱִÐÐshutdown abortºó£¬ÖØÐÂÆô¶¯Êý¾Ý¿âÐèÒªºÜ³¤Ê±¼ä¡£


Ïà¹ØÎĵµ£º

OracleË÷Òý±Ê¼Ç

 Ò».B-TreeË÷Òý(b-tree index)
1. Ñ¡ÏîÔñË÷Òý×ֶεÄÔ­Ôò: 
ÔÚWHERE×Ó¾äÖÐ×îÆµ·±Ê¹ÓõÄ×ֶΠ
Áª½ÓÓï¾äÖеÄÁª½Ó×ֶΠ
Ñ¡Ôñ¸ßÑ¡ÔñÐÔµÄ×Ö¶Î(Èç¹ûºÜÉÙµÄ×Ö¶ÎÓµÓÐÏàֵͬ,¼´Óкܶà¶ÀÌØÖµ,ÔòÑ¡ÔñÐԺܺÃ) 
ORACLEÔÚUNIQUEºÍÖ÷¼ü×Ö¶ÎÉÏ×Ô¶¯½¨Á¢Ë÷Òý 
ÔÚÑ¡ÔñÐԺܲîµÄ×Ö¶ÎÉϽ¨Ë÷ÒýÖ»ÓÐÔÚÕâ¸ö×Ö¶ÎµÄ ......

ÆÀ:Å·ÃË×èÄÓOracle¼æ²¢Sun

 ËäÈ»ÎÒÃÇÖªµÀÉ̵À¹îÒ²,ÕâÆªÎÄÕ»¹ÊÇÄܹ»ÈÃÎÒÃÇ´ÓijЩ½Ç¶ÈÉϹ۲졣±ÈÈçÅ·ÃËÓµ»¤¿ª·Å¼¼Êõ,Å·ÃËÒªÆÀ¼ÛOracleÓµÓÐMySQLºÍJavaËùÔì³ÉµÄÓ°Ïì,everything is politicalÒÑÈ»ÊÇÒ»Ìõ´ó·¹æÔòÁË£¬ÎÒÃÇ»¹ÊÇÄܹ»Ðá³öÕâ¸ö»Ï×ÓÏÂÃæÂôµÃ»¹ÊÇÀûÒæ¹Ï·ÖµÄÀϾÀ¸ð£¬×ܲ»ÄÜɶºÃʶ¼ÈÃÄãÃÀ¹úÀÐÕ¼ÁË¡£µ«ÊÇÎÒÏëÒ²Ö»ÊǸöʱ¼äÎÊÌ⣬ҲÐí±³ºóÍÆÊÖÒ ......

oracle»ù´¡ÖªÊ¶1

 
1¡¢Ä¬ÈÏÊÂÀý£º
Óû§Ãû£ºscottÃÜÂ룺tiger Ö÷»ú×Ö·û´®£º±¾»ú¿ÉÒÔΪ¿Õ
2¡¢Æô¶¯·½·¨£º
ÔËÐУºsqlplus scott/tiger@lhd
3¡¢SQLPLUS»ù±¾ÃüÁ
Desc£ºÏÔʾ±í¡¢ÊÓͼ½á¹¹  desc ±íÃû£¬ÊÓͼ
List£ºÁгöSQL»º³åÇøÇøÖеÄÒ»Ðлò¶àÐÐÃüÁîÓï¾ä
Exit£ºÍ˳ö
4¡¢³£ÓõÄÊý¾Ý×Öµä(ÈýÖÖǰ׺£ºUSER£¬ALL£¬DBA)
USER_TABLE ......

oracle update from ÎÊÌ⣡

  update t_tmprpt_firstreplycosttime t
set (t.firstreplytime,
t.dealstaff,
t.firstreplyfailcontent)
= (select a.suggesttime,
a.suggester,
substr(a.remark,instr(a.remark,'¡¿',1)+2)
from t_wf_suggesthis a
......

OracleÊý¾Ý¿âËø

 ¡¾×ª¡¿http://topic.csdn.net/t/20031006/10/2327335.html
ÎÄÕÂÀ´×Ô   www.ncn.cn     (¾ÛÏÍׯ)  
  =======================================================  
   
  ORACLEÀïËøÓÐÒÔϼ¸ÖÖģʽ:  
  0£ºnone  
  1£ºnull   ¿Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ