ORACLEÅàѵС¼Ç£ÉîÛڱ߼ì×ÜÕ¾
Õâ´ÎÊÇÓ¦ÀèÃ÷ÍøÂçµÄÑûÇ룬ȥÉîÛڱ߷À¼ì²éÖ¸»ÓÖÐÐĽøÐÐORACLEµÄÅàѵ¡£Åàѵ·Ö¶þÆÚ£¬Ã¿ÆÚ4Ì죬ÅÅÔÚAIXµÄÅàѵ֮ºó¡£
ÉϿεĵصã¾ÍÔÚÂÞºþ¿Ú°¶£¬Ñ§Ô±À´×Ô¸÷¸ö·ÖÕ¾£ºÉîÛÚÍ壬»Ê¸Ú¿Ú°¶£¬ÂÞºþ¿Ú°¶£¬×ÜÖ¸»ÓÖÐÐÄ£¬Ð¡Ã·É³£¬ÉõÖÁ»¹ÓÐÉÇÍ·ºÍ»ÝÖݵÄͬÐйýÀ´Ìý¿Î£¬ËùÒÔ˵ÅàѵµÄ¹æ¸ñ»¹ÊÇͦ¸ßµÄ¡£ÆäÖÐÓÐһλÑ¹Ù£¬Ìý˵»¹ÊǸ߼¶¾¯¹Ù£¬ËäȻ˾ְͦ¸ß£¬²»¹ý£¬ÔÚËýµÄ´øÁìÏ£¬Ñ§Ô±ÃǶ¼·Ç³£ÈÏÕ棬˿ºÁûÓÐÕþ¸®»ú¹ØÄÇÖÖ”×ß¹ý³¡”µÄ×÷·ç¡£ËûÃÇÔÚС÷ɳµÄÑз¢»ùµØ»¨ÁË2Äêʱ¼ä£¬¿ª·¢ÁËÒ»Ìױ߼ìϵͳ£¬ÃüÃûΪ“÷ɳϵͳ”¡£Ã·É³ÏµÍ³µÄOS²ÉÓÃIBMµÄAIX£¬Êý¾Ý¿â²ÉÓÃORACLE 9I¡£¾Ý˵“÷ɳϵͳ”¼Æ»®ÔÚÈ«¹ú±ß¼ìÍƹ㡣
´Ë´ÎÅàѵ¿É˵ÊǷdz£³É¹¦¡£ËäÈ»ÊǾ¯²ì£¬¿ÉÊÇѧԱ·Ç³£ÈÏÕæºÃѧ¡£ÔÚÅàѵÆڼ䣬»¹°ïËûÃǽâ¾öÁËÒ»¸öССµÄORACLE¸´ÖƵÄÎÊÌ⣺ËûÃÇÐèÒª²»¶¨ÆÚͬ²½ORACLE¿ª·¢Êý¾Ý¿â¡£ÎÒÎÊËûÃÇÔ´Êý¾Ý¿â¿É²»¿ÉÒÔDOWN»ú£¬ËûÃÇ˵¶¼ÊÇ¿ª·¢Êý¾Ý¿â£¬Êý¾ÝÁ¿²»´ó£¬¶¼¿ÉÒÔDOWN»ú¡£×îÖÕ£¬ÎÒ½¨ÒéËûÃÇ¿ÉÒÔ²ÉÓø´ÖÆORACLEÎïÀíÎļþµÄ·½·¨£¬ÕâÖÖ·½·¨¶ÔÓÚËûÃÇÀ´ËµºÃÀí½â£¬¸úËûÃÇƽ³£¸´ÖÆÎļþ²î²»¶à£¬Ö»²»¹ýÒªÀí½âһЩ¸ÅÄʵÀý,ORACLEÎïÀí½á¹¹,¿ÚÁîÎļþ,¼àÌý,·þÎñ,ÍøÂçÁ¬½ÓÒÔ¼°Ò»Ð©ÊµÀý²ÎÊý.
¾Ý˵ÉîÛڱ߼ìÒÔÇ°ÊÇÊôÓÚ²¿¶Ó,ÏÖÔڸĹ鹫°²²¿Áìµ¼ÁË,Á¥Êô¹«°²²¿µÚX¾Ö£¬²»¹ý£¬²»Í¬Óڵط½¹«°²£¬ËûÃDz»¹éµØ·½Õþ¸®Áìµ¼£¬¹ÜµÄÊÂҲûÓй«°²µÄÄÇô¶à£¬ËùÒÔÒ²Ëã²»ÉÏÊÇʲôȨÁ¦²¿ÃÅ¡£²»¹ý£¬ËûÃǵÄʳÌÃÊÇÎÒËù¼û¹ýµÄ×îºÃµÄʳÌÃÖ®Ò»(ÔÚÑغÓ·µÄ±ß¼ìÖ¸»ÓÖÐÐÄÄÚ)£¬ÄǾø¶ÔÊDZö¹Ý¼¶±ðµÄ£¬ÓÐרÃŵķþÎñÉú£¬»ïʳµÄ±ê×¼ºÜ¸ß£¬²»¹ý¾ÝѧԱ½²ËûÃÇƽʱҲ²»ÔÚÕâ³Ô£¬Ö»ÔÚÅàѵÆÚ¼äÏíÊÜÕâÑùµÄ´ýÓö£¬ÕâÀïƽ³£ÊÇÁìµ¼¼¶±ðµÄÑçϯ¡£ÆäÖÐÒ»¸öÄêÇáµÄ¾¯¹Ù£¬½ÐÔø¹ÚУ¬ÅàѵÍêºóÎÒÃÇ»¹»¥ÁôÁËÁªÏµ·½Ê½£¬ºÍÎÒ̸ÆðÁËÏã¸ÛµÄÁ®Õþ¹«Êð¡£¾Ý˵Ïã¸ÛµÄ¹«ÎñÔ±ºÜÉÙ·¢ÉúÖ°Îñ·¸×ÕâºÍËûÃÇÓÐÒ»¸ö¶ÀÁ¢µÄ¼à¹Ü»ú¹¹-Á®Õþ¹«Êð·Ö²»¿ª,Ò»µ©Ïã¸ÛµÄ¹«ÎñÔ±Óз¸×ï¼Ç¼£¬ÔòËûÃÇËùÓеÄÍËÐݺóÒ»Çи£Àû(ÍËÐݽð£¬ÑøÀϽðµÈ)½«±»°þ¶á£¬¶øÕâЩ¸£Àû¶ÔËûÃǺÜÖØÒª£¬×ã¹»ËûÃÇÍËÐݺó¼ÒÍ¥¹ýÉÏÏ൱ÓÅÔ£µÄÉú»î£¬ËùÒÔ£¬Ïã¸ÛµÄ¹«ÎñÔ±ºÜÉÙ»áȥðÕâ¸ö·çÏÕÈ¥½øÐÐÌ°ÎÛäÂÖ°µÈ·¸×ï¡£ÕâºÍмÓƵē¸ßнÑøÁ®”ËƺõÓÐÒìÇúͬ¹¤Ö®Ã²»¹ýÔڴ󽣬ÎÒÏàÐŻᱻ“Ò컯”£¬ÊÂʵÉÏ£¬Ðí¶àÔÚÈ«ÊÀ½çÖ¤Ã÷ÊǺܺõÄÖƶȻòÌåÖÆ£¬ÒýÈëµ½Öйú£¬ÍùÍùûÓз¢ÉúÔ¤ÆÚµÄЧ¹û¡£
ºÇºÇ£¬ÕâÊdz¶Ïл°ÁË¡£×÷ΪITÈËÊ¿£¬Ò²Ö»ÊǺÍËûÃÇËæ±ãÁÄÁÄ£¬ÔÛÒ²²»ÔÚÐС£ÓÉÓÚʱ¼ä»¹Ô磬ÎÒÃǼ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
oracle 9i online documentation:
http://www.oracle.com/pls/db92/db92.docindex?remark=homepage
oracle 10g online documentation:
http://www.oracle.com/pls/db102/homepage
oracle 11g online documentation:
http://www.oracle.com/pls/db111/homepage ......
oracle£¨²âÊÔ»·¾³Îªoralce10g£©ÖУ¬ÈôΪͬһ¿âÖУ¬²éѯʱÓÚ±íÃûÇ°Ìí¼ÓÓû§Ãû¼´¿É¡£ ÈôΪ¿ç¿â´¦Àí£¬ÓÐÁ½ÖÖ·½·¨¡£
µÚÒ»ÖÖ·½·¨£¬ÓÃDB_link´¦Àí¡£¶øÆä²»×ãÖ®´¦Îª²»ÄܲÙ×Ý´ó×ֶΡ£ÈçϲÙ×÷£º
&nb ......
ÐòÁУ¨SEQUENCE£©ÐòÁÐÊÇÒ»Êý¾Ý¿â¶ÔÏó£¬ÀûÓÃËü¿ÉÉú³ÉΨһµÄÕûÊý¡£Ò»¸öÐòÁеÄÖµÊÇÓÉÌØÊâµÄOracle³ÌÐò×Ô¶¯Éú³É£¬Òò´ËÐòÁбÜÃâÁËÔÚÓ¦Óà ²ãʵÏÖÐòÁжøÒýÆðµÄÐÔÄÜÆ¿¾±¡£¸ÃÐòÁÐΪÉÏÉýÐòÁУ¬ÓÉ1¿ªÊ¼£¬ÔöÁ¿Îª1£¬Ã»ÓÐÉÏÏÞ¡£ÔÚÉýÐòʱ£¬ÐòÁпɴӱÈ×îСֵ´óµÄÖµ¿ªÊ¼£¬È±Ê¡ÖµÎªÐòÁеÄ×îСֵ¡£¶ÔÓÚ½µ Ðò£¬ÐòÁпÉÓɱÈ×î´óֵСµÄÖµ¿ªÊ¼£¬È±Ê¡ ......
ʹÓÃOracleÌØÓеIJéѯÓï·¨, ¿ÉÒԴﵽʰ빦±¶µÄЧ¹û
1. Ê÷²éѯ
create table tree (
id number(10) not null primary key,
name varchar2(100) not null,
super number(10 ......