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
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
¡¡¡¡Sun±¾À´¾ÍºÜÀ÷º¦£¬Î޷ǽüÄêÀ´Ó¯ÀûÄÜÁ¦ÓÐËùϽµ£¬Oracle¿¿Êý¾Ý¿â׬ÁË´ó°Ñ³®Æ±¡£Á½¼ÒÁªºÏÒÔºóÐγɓCPU-¸ß¶ËÖ÷»ú-²Ù×÷ϵͳ-¿ª·¢»·¾³-Êý¾Ý¿â-ÓïÑÔ-Ó¦ÓÃÈí¼þ”Ò»ÌõÁú²úÆ·Ïߣ¬´ËǰÓдËÄÜÁ¦µÄÖ»ÓÐIBM¡£
¡¡¡¡Á½¼Ò½ñºóµÄÕÐÅÆ²úÆ·¶Ô±ÈÈçÏ£º
SUN&Oracle IBM
CPU Ultra Power
Ö÷»ú UltraϵÁÐ RS,ASµÈPowerϵÁ ......
¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿â
ϵͳǰ,ÓÐ˶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQL
µÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
j8m ......
Ŀǰ£¬ÕýÔò±í´ïʽÒѾÔںܶàÈí¼þÖеõ½¹ã·ºµÄÓ¦Ó㬰üÀ¨*nix£¨Linux, UnixµÈ£©£¬HPµÈ²Ù×÷ϵͳ£¬PHP£¬C#£¬JavaµÈ¿ª·¢»·¾³¡£
Oracle 10gÕýÔò±í´ïʽÌá¸ßÁËSQLÁé»îÐÔ¡£ÓÐЧµÄ½â¾öÁËÊý¾ÝÓÐЧÐÔ£¬ ÖØ¸´´ÊµÄ±æÈÏ, Î޹صĿհ׼ì²â£¬»òÕß·Ö½â¶à¸öÕýÔò×é³É
µÄ×Ö·û´®µÈÎÊÌâ¡£
Oracle 10gÖ§³ÖÕýÔò±í´ïʽµÄËĸöк¯Êý ......
Ò»¸öÓû§¿ÉÒÔʹÓÃÒ»¸ö»ò¶à¸ö±í¿Õ¼ä£¬Ò»¸ö±í¿Õ¼äÒ²¿ÉÒÔ¹©¶à¸öÓû§Ê¹Óá£Óû§ºÍ±í¿Õ¼äûÓÐÁ¥Êô¹ØÏµ£¬±í¿ÕÊÇÒ»¸öÓÃÀ´¹ÜÀíÊý¾Ý´æ´¢Âß¼¸ÅÄ±í¿Õ¼äÖ»ÊǺÍÊý¾ÝÎļþ·¢Éú¹ØÏµ£¬Êý¾ÝÎļþÊÇÎïÀíµÄ£¬Ò»¸ö±í¿Õ¼ä¿ÉÒÔ°üº¬¶à¸öÊý¾ÝÎļþ£¬¶øÒ»¸öÊý¾ÝÎļþÖ»ÄÜÁ¥ÊôÒ»¸ö±í¿Õ¼ä¡£
Óû§ÊôÓÚÊý¾Ý¿âʵÀýµ ......