OracleÆô¶¯¹ý³ÌÏê½â ½éÉܼ°ÃüÁ»¹ÓйرÕ
OracleÆô¶¯¹ý³Ì½éÉܼ°ÃüÁ»¹Óйرա£
дÔÚÇ°Ãæ£ºÆô¶¯Êý¾Ý¿âǰ£¬ÇëÏÈÆô¶¯¼à³ÌÐò¡£
lsnrctl start
Æô¶¯µÄÈý¸ö²½Ö裬ÒÀ´ÎΪ1.´´½¨²¢Æô¶¯ÊµÀý¡¢2.×°ÔØÊý¾Ý¿â¡¢3.´ò¿ªÊý¾Ý¿â¡£
¿ÉÒÔͨ¹ýÃüÁîstartupÀ´ÊµÏÖ¡£
startup ÃüÁî¸ñʽ
startup [ nomount | mount | open | force ] [ restrict ] [ pfile=filename ];
·½·¨1 -- startup nomount ; alter database mount ;alter database open
·½·¨2 -- startup mount ; alter database open
·½·¨3 -- startup »ò startup open
ÔÚ½øÈëijÖÖģʽºó£¬¿ÉÒÔͨ¹ýalter databaseÀ´ÌáÉýµ½¸ü¸ßµÄģʽ¡£µ«ÊÇÎÞ·¨½µµÍÖÁÇ°ÃæµÄģʽ¡£
ÊéÉÏдµÄտĥߴ£¬¾ÍÊÇ˵ÄãÔÚstep2ÕâÀÄã¿ÉÒÔͨ¹ýalter databaseµ½step3,µ«ÊÇÄã²»Äܵ½step 1.
startup force
Ç¿ÖÆÆô¶¯£¬¿ÉÓÃÓÚ¸÷ÖÖģʽ¡£Õý³£µÄÆð²»À´£¬¾ÍÊÔÊÔÕâ¸ö¡£
startup restrict
restrictģʽ»á½«Êý¾Ý¿âÖÃÓÚopenģʽ£¬´ËʱֻÓÐrestricted sessionȨÏÞµÄÓû§²ÅÄÜ·ÃÎÊÊý¾Ý¿â¡£
ÓÃÓÚά»¤¶¯×÷¡£Î¬»¤Íê³Éºó£¬Çë½ûÓÃrestricted sessionȨÏÞ£¬ÒÔ±ãÆÕͨÓû§µÄÁ¬½Ó¡£ÈçÏ£º
alter system disable restricted session
1:´´½¨²¢Æô¶¯ÊµÀý stratup nomount
´ËģʽÏÂÖ´ÐÐά»¤¶¯×÷£º
a:ÔËÐÐÒ»¸ö´´½¨ÐÂÊý¾Ý¿âµÄ½Å±¾
b:ÖØ½¨¿ØÖÆÎļþ
2:×°ÔØÊý¾Ý¿â startup mount
´ËģʽÏÂÖ´ÐÐά»¤¶¯×÷£º
a:ÖØÃüÃûÊý¾ÝÎļþ
b:Ìí¼Ó¡¢É¾³ý¡¢ÖØÃüÃûÖØ×öÈÕÖ¾Îļþ
c:Ö´ÐÐÊý¾Ý¿âÍêÈ«»Ö¸´²Ù×÷
d:¸Ä±äÊý¾Ý¿âµÄ¹éµµÄ£Ê½¡£
3:´ò¿ªÊý¾Ý¿â stratup µÈͬÓÚ startup open
´Ëģʽ״̬Ï¡£ÈκξßÓÐcreate sessionȨÏÞµÄÓû§¶¼¿ÉÒÔÁ¬½Óµ½Êý¾Ý¿â¡£½øÐг£¹æÊý¾Ý¿â²Ù×÷¡£
¹Ø±ÕÊý¾Ý¿â,ͨ¹ýshutdownÃüÁî
shutdown ÃüÁî¸ñʽ
shutdown [ normal | transactional | immediate | abort ];
normal:
a:×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó
b:µÈ´ýÁ¬½ÓµÄÓû§Ö÷¶¯¶Ï¿ª£¬ÕýÔÚÁ¬½ÓµÄÓû§¿ÉÒÔ¼ÌÐø¹¤×÷£¬ÉõÖÁÌύеÄʵÎñ¡£
c:Ò»µ©ËùÓеÄÓû§¶Ï¿ªÁ¬½Ó£¬²Å½øÐйرգ¬Ð¶ÔØÊý¾Ý¿â£¬²¢ÖÕֹʵÀý¡£
Ó°Ï죺µÈºÜ¾Ã¡£
transactional:
a:×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó,ͬʱ×èÖ¹²úÉúеÄÊÂÎñ¡£
b:µÈ´ýδÌá½»µÄʵÎñ£¬Ìá½»Íê±Ïºó£¬ÇжÏÓû§µÄÁ¬½Ó¡£
c:Ò»µ©ËùÓеÄÓû§¶Ï¿ªÁ¬½Ó£¬²Å½øÐйرգ¬Ð¶ÔØÊý¾Ý¿â£¬²¢ÖÕֹʵÀý¡£
Ó°Ï죺×îºÃµÄ¹Ø±ÕÊý¾Ý¿âµÄ·½Ê½¡£
immediate:
a:×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó,ͬʱ×èÖ¹²úÉúеÄÊÂÎñ¡£
b:ÈκÎδÌá½»µÄʵÎñ¶¼»á±»»Ø¹ö¡£
c:Oracle²»ÔٵȴýÓû§Ö÷¶¯¶Ï¿ªÁ¬½Ó£¬¶øÊÇÖ±½Ó¹Ø±Õ¡¢Ð¶ÔØÊý¾Ý¿â£¬²¢ÖÕֹʵÀý¡£
Ó°Ï죺ÓÐЩ
Ïà¹ØÎĵµ£º
Êý¾ÝownerºÍÊý¾Ý²Ù×÷ÕßÒÔ¼°´úÂë·ÃÎÊʹÓò»Í¬µÄÓû§·ÃÎÊ£¬Ê¹ÓÃÊÚȨµÄ·½Ê½½øÐзÃÎÊ¡£
Êý¾Ý±í´´½¨Ê±Ê¹ÓÃͬÒå´Ê´´½¨
ÊÚȨʱ×îºÃ²»ÒªÊ¹ÓÃwith grant option
ÒÔǰ²»Ì«Ã÷°×ͬÒå´ÊµÄʹÓã¬ÏÖÔÚÖªµÀÁË¡£±È½ÏºÃµÄÓ¦ÓþÍÊÇ´´½¨±íµÄ±ðÃû
create public ͬÒå´Ê tableName for owner.tableName
¸øÊÓͼÊÚȨ¿ÉÒÔʹµÃÓû§·ÃÎʲ»¾ß ......
Ò» Êý¾Ý¿âµÄÊÂÎñ´¦Àí
¶¨Ò壺ÊÂÎñÊÇÒ»×éÏà¹ØµÄÊý¾Ý¸Ä±äµÄÂß¼¼¯ºÏ¡£ÔÚÒ»¸öÊÂÎñÖеÄÊý¾Ý¸Ä±ä£¨DML£©±£³Ö×ÅÒ»ÖµÄ״̬£¬Êý¾ÝµÄ¸Ä±äͬʱ³É¹¦»òÕßͬʱʧ°Ü¡£
¶þ Êý¾Ý¿âµÄÊÂÎñÓÉÏÂÁÐÓï¾ä×é³É
Ò»×éDMLÓï¾ä£¬Ð޸ĵÄÊý¾ÝÔÚËûÃÇÖб£³ÖÒ»ÖÂ
Ò»¸ö DDL (Data Define Language) Óï¾ä
Ò»¸ö DCL (Data Control Language)Óï¾ä
1¡¢¿ª ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
³ÉÔ±º¯ÊýºÍ¹ý³Ì
¹¹Ô캯Êý·½·¨
-oracleµÄÿ¸ö¶ÔÏó¾ùÓÐÒ»¸öÄÚÖõĹ¹Ô캯Êý·½·¨
-ÓÃÓÚ´´½¨¶ÔÏóµÄÒ»¸öʵÀý
-ÎÞÐèÏÔʽµØ¶¨Òå
-Óë¶ÔÏóÀàÐÍͬÃû
¶¨Òå¶ÔÏóÀàÐÍ
create or replace
type persontype as object
(
id int,
name varchar(20),
member function ......