Oracle DBA ÈëÃÅ¡¢½ø½×ѧϰ·Ïßͼ
¾³£ÓÐDBAÅóÓÑÃÇÏòÎÒ×Éѯ£¬Èç¹û´òËã½øÈëDBAÕâÒ»ÐУ¬Ó¦¸ÃÔõÑùÈëÃÅ£¬»òÕß¿ÉÒÔͨ¹ýÔõÑùÒ»¸ö·ÏßͼÀ´½øÐÐѧϰ¡£
¹ØÓÚÕâ¸öÖ÷Ì⣬ÆäʵÍøÂçÉÏÒѾÓÐÁËһЩÄÚÈÝ¿ÉÒԲο¼¡£µ«ÊǼÈÈ»Õâô¶àÅóÓÑÎÊÌ⣬ÎҾͽ«Ö®Ç°Ð´ºÃµÄÒ»µãÄÚÈÝ·¢±í³öÀ´¡£
ËãÊǶԴó¼ÒµÄÒ»¸ö»Ø´ð£¬Èç¹ûÄܹ»ÓÐËù½è¼øÄÇÊÇ×îºÃµÄ¡£
ÎÒµÄÕâ·Ý·Ïßͼ£¬ÊÇ°´ÕÕÎÒд×÷µÄÁ½±¾ÊéÀ´Äⶨ³öÀ´µÄ£¬ÒòΪÕâÁ½±¾ÊéÒ²ÕýÊÇÎÒѧϰ¡¢³É³¤µÄ·Ïß¡£
²Î¿¼Ò»ÏÂÎÒ×ß¹ýµÄ·£¬ÎÒµÄ×ܽáÓë¾Ñ飬ҲÐí´ó¼ÒÄܹ»ÓÐЩÐíµÄÊÕ»ñ¡£
ÄÇô·Ïßͼ ÕæµÄÊÇÓÐÒ»ÕÅͼ£¬ÕâÊÇÎÒ½«¡¶ÉîÈëdz³öOracle¡·ºÍ¡¶ÑÐò½¥½øOracle¡·Á½±¾ÊéµÄÄÚÈÝ×ÛºÏÕûÀí³öÀ´µÄ£¬Çë¿´ÏÂͼ£º
µ±È»³ý´ËÖ®Í⣬ÎÒÍƼö´ó¼ÒÔĶÁÒ»ÏÂÎÒ¼¸±¾ÊéµÄÐòÑԵȣ¬ÄÇÀïÓÐÎÒµÄÐĵÃÓë¸ÐÑÔ£¬¿ÉÒÔ×÷ΪѧϰµÄ²Î¿¼£º
¡¶ÉîÈëdz³öOracle¡·Ò»ÊéÐòÑÔ
¡¶ÑÐò½¥½øOracle¡·Ò»ÊéÐòÑÔ
¡¶OracleÊý¾Ý¿âÐÔÄÜÓÅ»¯¡·Ò»ÊéÐòÑÔ
OracleµÄѧϰ¹óÔÚ¼á³Ö£¬Ï£Íûÿ¸öÈÈÖÔÓڴ˵ÄÈ˶¼Äܹ»Ñ§ÓÐËù³É£¡
from: http://www.eygle.com/archives/2008/10/oracle_dba_study_road.html
Ïà¹ØÎĵµ£º
oracleÆô¶¯·½Ê½ÓëÃüÁî²ÎÊý»ã×Ü
±¾ÎÄÖ÷ÒªÊǶÔoracleµÄÆô¶¯·½Ê½ºÍÏà¹ØµÄÃüÁî²ÎÊý½øÐÐÒ»¸ö»ã×Ü£¬ÓÃÒÔ¼ÓÉîÓ¡Ïó¡£
OracleµÄÆô¶¯·½Ê½£º
startup nomount
startup mount
startup open (startupµÄĬÈÏÑ¡Ïî)
ÆäËû³£ÓõIJÎÊý£ºread only ,read write ,force,restrict
ÕâЩ²ÎÊý¿ÉÒÔÒ»ÆðʹÓÃ,±ÈÈç startup Óë startup open read ......
http://blog.csdn.net/mustbelove/archive/2007/04/17/1567836.aspx(ת)
1 year=1*12 months
1 day=24
hours=24*(1*60mins)=24*60*(1*60 seconds)
1 week =7 days
×¢Ò⣺
ºÚÉ«×ÖÌåÊÇ oracle
8i£¬9i¶¼¿ÉÒÔʹÓõĺ¯Êý£¬
À¶É«×ÖÌåÊÇ Oracle
9i
ÐÂ
ÔöµÄ²¿·Ö¡£
Çë´ó¼ÒÔÚʹÓÃʱ£¬×¢Òâ°æ±¾ÏÞÖÆ¡£
add_mon ......
Ò»¸öÔµĵÚÒ»Ìì
´úÂë (Ë«»÷´úÂ븴ÖƵ½Õ³Ìù°å)
SELECT to_date(to_char(SYSDATE,'yyyy-mm')||'-01','yyyy-mm-dd')
from dual
sysdate ΪÊý¾Ý¿â·þÎñÆ÷µÄµ±Ç°ÏµÍ³Ê±¼ä¡£
to_char Êǽ«ÈÕÆÚÐÍתΪ×Ö·ûÐ͵ĺ¯Êý¡£
to_date Êǽ«×Ö·ûÐÍתΪÈÕÆÚÐ͵ĺ¯Êý£¬Ò»°ãʹÓà yyyy-mm-dd hh24:mi:ss¸ñʽ£¬µ±Ã»ÓÐÖ¸¶¨Ê±¼ä²¿·Öʱ£¬ÔòÄ ......
ORACLE º¯Êý¿ª·¢
1¡¢½¨Á¢º¯ÊýµÄÓï·¨£º
CREATE [OR REPLACE] FUNCTION º¯ÊýÃû
[ (arg1 [mode] datatype[,........])] --µ±Ö¸¶¨²ÎÊýÊý¾ÝÀàÐÍʱ£¬²»ÄÜÖ¸¶¨Æ䳤¶È¡£modeÖµ£ºIN¡¢OUT¡¢IN OUT£¬µ±mode δָ¶¨Ê±£¬±íʾΪIN
RETURN datatype ......