Oracle ±Ê¼Ç
µÚ1Ò³
1. Oracle µÄʹÓÃ
1.1. SQLPLUS µÄÃüÁî
³õʼ»¯±íµÄλÖãº
set
NLS_LANG=american_america.us7ascii (ÉèÖñàÂë²Å¿ÉÒÔʹÓÃÏÂÃæ½Å±¾)
cd
$ORACLE_HOME/rdbms cd demo summit2.sql
*********************************
ÎÒÃÇĿǰʹÓõÄÊÇoralce 9i
9201 °æ±¾
select * from
v$version;
»Ö¸´Á·Ï°±íÃüÁ
sqlplus **/** @summit2.sql //shellÒªÔÚÕâ¸öÎļþµÄλÖá£
µÇ½ oracleµÄÃüÁ
sqlplus Óû§Ãû/ÃÜÂë
show user
ÏÔʾµ±Ç°µÇ½µÄÉí·Ý.
set pause on
set pause off
·ÖÒ³ÏÔʾ.
oracle ÖÐĬÈÏÈÕÆÚºÍ×Ö·ûÊÇ×ó¶ÔÆë£¬Êý×ÖÊÇÓÒ¶ÔÆë
table or view
does not
exist ; ±í»òʾͼ²»´æÔÚ
edit ÃüÁîÓÃÓÚ×Ô¶¯´ò¿ªvi Ð޸ĸÕÐÞÖ´ÐйýµÄ sql µÄÃüÁî¡£
Ð޸ķ½·¨¶þ£º
l 3 Ïȶ¨Î»µ½ÐÐ c /¾É´®/д®
Ö´Ðгö´íʱ£¬ÀûÓôíÎóºÅÀ´²é´íÎó:
!oerr ora
942 (×°Íêϵͳºó»á×°Ò»¸ö oerr ¹¤¾ß£¬ÓÃÓÚͨ¹ý´íÎóºÅÀ´²é¿´´íÎóµÄ¾ß
ÌåÐÅÏ¢)
ÏëÔÚ sql ÖÐÖ´ÐÐ
unix ÃüÁîʱ£¬°ÑËùÓеÄÃüÁîǰ¼ÓÒ»¸ö!¾Í¿ÉÒÔ£¬ »òÕß
host( ÓÃÓÚ
´Ó sql ´ÓÇл»ÖÁunix»·¾³ÖÐÈ¥)
/*** ³õ´ÎʹÓÃʱעÒâ ****
ÔËÐнDZ¾Ê±µÄÃüÁ
ÏÈÇл»µ½ unix»·¾³Ï£¬cd
$oracle_home cd sqlplus cd demo ÏÂÃæÓÐÁ½¸ö½Ç±¾
½¨±íÓï¾ä¡£ µÚ2Ò³
@demobld.sql
sqlplus
nanjing/nanjing @demobid.sql Ö±½ÓÔËÐнDZ¾£¬ºóÃæ¸úµ±Ç°Ä¿Â¼»òÕßÊǾø¶Ô
·¾¶
±£´æ¸Õ²ÅµÄ sql Óï¾ä£º save ÃüÁî µÚ¶þ´Î±£´æÊ±ÒªÌ滻֮ǰµÄ½Ç±¾ save
ÎļþÃû
replace
°Ñ¸Õ²Å±£µÄ sql ÖØÐ·ÅÈë buffer ÖÐ
spool on ¿ªÆô¼Ç¼
spool off ¹Ø±Õ¼Ç¼
spool ÎļþÃû ´ËÃüÁî»á°ÑËùÓеIJÙ×÷´æÔÚij¸öÎļþÖÐÈ¥
³£¼ûËõд£º
nls national
langua
Ïà¹ØÎĵµ£º
1.¿Í»§¶ËÁ¬½ÓÖÁoralce:
Ê×Ïȿͻ§¶ËÁ¬½ÓÖÁoracleµÄ¼àÌýÆ÷,È»ºó¼àÌýÆ÷·ÖÅäÒ»¸öÊý¾Ý¿âʵÀý(ÕâÀïµÄÊÇʵÀý)¸ø¿Í»§¶Ë,È»ºó¿Í»§¶ËÒÔºó¾ÍÖ±½ÓÓëÕâ¸öÊý¾Ý¿âʵÀý½øÐÐÁ¬½Ó,Ö±ÖÁ¶Ï¿ªÓëoracleµÄÁ¬½Ó.
2.Ìá½»sql:
(1)¿Í»§¶ËÓû§Ìá½»Ò»¸ösql ......
¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿â
ϵͳǰ,ÓÐ˶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQL
µÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
j8m ......
ÖØ×öÈÕÖ¾ÎļþÊÇOracleÊý¾Ý¿âÖÐÒ»Öַdz£ÖØÒªµÄÈÕÖ¾Îļþ£¬Ò²ÊÇÆäÒ»¸öºÜÓÐÌØÉ«µÄ¹¦ÄÜ¡£ÖØ×öÈÕÖ¾Îļþ»á¼Í¼¶ÔÓÚÊý¾Ý¿âµÄÈκβÙ×÷£¬ÈçÀûÓÃDMLÓï¾ä»òÕßDDLÓï¾ä¶ÔÊý¾Ý½øÐиü¸Ä£¬»òÕßÊý¾Ý¿â¹ÜÀíÔ±¶ÔÊý¾Ý¿â½á¹¹½øÐиü¸Ä£¬¶¼»áÔÚÖØ×öÈÕÖ¾ÖнøÐмǼ¡£
¡¡¡¡¿É¼û£¬µ±Êý¾Ý±»ÒâÍâµÄɾ³ý»òÕßÐ޸ģ¬ÎÒÃÇ¿ÉÒÔÀûÓÃÖØÐÂÈÕÖ¾Îļþ½øÐлָ´; µ±³ö ......
Ò»¸öÓû§¿ÉÒÔʹÓÃÒ»¸ö»ò¶à¸ö±í¿Õ¼ä£¬Ò»¸ö±í¿Õ¼äÒ²¿ÉÒÔ¹©¶à¸öÓû§Ê¹Óá£Óû§ºÍ±í¿Õ¼äûÓÐÁ¥Êô¹ØÏµ£¬±í¿ÕÊÇÒ»¸öÓÃÀ´¹ÜÀíÊý¾Ý´æ´¢Âß¼¸ÅÄ±í¿Õ¼äÖ»ÊǺÍÊý¾ÝÎļþ·¢Éú¹ØÏµ£¬Êý¾ÝÎļþÊÇÎïÀíµÄ£¬Ò»¸ö±í¿Õ¼ä¿ÉÒÔ°üº¬¶à¸öÊý¾ÝÎļþ£¬¶øÒ»¸öÊý¾ÝÎļþÖ»ÄÜÁ¥ÊôÒ»¸ö±í¿Õ¼ä¡£
Óû§ÊôÓÚÊý¾Ý¿âʵÀýµ ......
Oracle°²×°Íêºó£¬ÆäÖÐÓÐÒ»¸öȱʡµÄÊý¾Ý¿â£¬³ýÁËÕâ¸öȱʡµÄÊý¾Ý¿âÍ⣬ÎÒÃÇ»¹¿ÉÒÔ´´½¨×Ô¼ºµÄÊý¾Ý¿â¡£
¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÎªÁ˱ÜÃâÂé·³£¬¿ÉÒÔÓÃ'Database Configuration Assistant'Ïòµ¼À´´´½¨Êý¾Ý¿â¡£
´´½¨ÍêÊý¾Ý¿âºó£¬²¢²»ÄÜÁ¢¼´ÔÚÊý¾Ý¿âÖн¨±í£¬±ØÐëÏÈ´´½¨¸ÃÊý¾Ý¿âµÄÓû§£¬ ......