Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ORACLEÅàѵС¼Ç£­ÉîÛڱ߼ì×ÜÕ¾

Õâ´ÎÊÇÓ¦ÀèÃ÷ÍøÂçµÄÑûÇ룬ȥÉîÛڱ߷À¼ì²éÖ¸»ÓÖÐÐĽøÐÐORACLEµÄÅàѵ¡£Åàѵ·Ö¶þÆÚ£¬Ã¿ÆÚ4Ì죬ÅÅÔÚAIXµÄÅàѵ֮ºó¡£
ÉϿεĵصã¾ÍÔÚÂÞºþ¿Ú°¶£¬Ñ§Ô±À´×Ô¸÷¸ö·ÖÕ¾£ºÉîÛÚÍ壬»Ê¸Ú¿Ú°¶£¬ÂÞºþ¿Ú°¶£¬×ÜÖ¸»ÓÖÐÐÄ£¬Ð¡Ã·É³£¬ÉõÖÁ»¹ÓÐÉÇÍ·ºÍ»ÝÖݵÄͬÐйýÀ´Ìý¿Î£¬ËùÒÔ˵ÅàѵµÄ¹æ¸ñ»¹ÊÇͦ¸ßµÄ¡£ÆäÖÐÓÐһλÑ¹Ù£¬Ìý˵»¹ÊǸ߼¶¾¯¹Ù£¬ËäȻ˾ְͦ¸ß£¬²»¹ý£¬ÔÚËýµÄ´øÁìÏ£¬Ñ§Ô±ÃǶ¼·Ç³£ÈÏÕ棬˿ºÁûÓÐÕþ¸®»ú¹ØÄÇÖÖ”×ß¹ý³¡”µÄ×÷·ç¡£ËûÃÇÔÚС÷ɳµÄÑз¢»ùµØ»¨ÁË2Äêʱ¼ä£¬¿ª·¢ÁËÒ»Ìױ߼ìϵͳ£¬ÃüÃûΪ“÷ɳϵͳ”¡£Ã·É³ÏµÍ³µÄOS²ÉÓÃIBMµÄAIX£¬Êý¾Ý¿â²ÉÓÃORACLE 9I¡£¾Ý˵“÷ɳϵͳ”¼Æ»®ÔÚÈ«¹ú±ß¼ìÍƹ㡣
 ´Ë´ÎÅàѵ¿É˵ÊǷdz£³É¹¦¡£ËäÈ»ÊǾ¯²ì£¬¿ÉÊÇѧԱ·Ç³£ÈÏÕæºÃѧ¡£ÔÚÅàѵÆڼ䣬»¹°ïËûÃǽâ¾öÁËÒ»¸öССµÄORACLE¸´ÖƵÄÎÊÌ⣺ËûÃÇÐèÒª²»¶¨ÆÚͬ²½ORACLE¿ª·¢Êý¾Ý¿â¡£ÎÒÎÊËûÃÇÔ´Êý¾Ý¿â¿É²»¿ÉÒÔDOWN»ú£¬ËûÃÇ˵¶¼ÊÇ¿ª·¢Êý¾Ý¿â£¬Êý¾ÝÁ¿²»´ó£¬¶¼¿ÉÒÔDOWN»ú¡£×îÖÕ£¬ÎÒ½¨ÒéËûÃÇ¿ÉÒÔ²ÉÓø´ÖÆORACLEÎïÀíÎļþµÄ·½·¨£¬ÕâÖÖ·½·¨¶ÔÓÚËûÃÇÀ´ËµºÃÀí½â£¬¸úËûÃÇƽ³£¸´ÖÆÎļþ²î²»¶à£¬Ö»²»¹ýÒªÀí½âһЩ¸ÅÄʵÀý,ORACLEÎïÀí½á¹¹,¿ÚÁîÎļþ,¼àÌý,·þÎñ,ÍøÂçÁ¬½ÓÒÔ¼°Ò»Ð©ÊµÀý²ÎÊý.
¾Ý˵ÉîÛڱ߼ìÒÔÇ°ÊÇÊôÓÚ²¿¶Ó,ÏÖÔڸĹ鹫°²²¿Áìµ¼ÁË,Á¥Êô¹«°²²¿µÚX¾Ö£¬²»¹ý£¬²»Í¬Óڵط½¹«°²£¬ËûÃDz»¹éµØ·½Õþ¸®Áìµ¼£¬¹ÜµÄÊÂҲûÓй«°²µÄÄÇô¶à£¬ËùÒÔÒ²Ëã²»ÉÏÊÇʲôȨÁ¦²¿ÃÅ¡£²»¹ý£¬ËûÃǵÄʳÌÃÊÇÎÒËù¼û¹ýµÄ×îºÃµÄʳÌÃÖ®Ò»(ÔÚÑغÓ·µÄ±ß¼ìÖ¸»ÓÖÐÐÄÄÚ)£¬ÄǾø¶ÔÊDZö¹Ý¼¶±ðµÄ£¬ÓÐרÃŵķþÎñÉú£¬»ïʳµÄ±ê×¼ºÜ¸ß£¬²»¹ý¾ÝѧԱ½²ËûÃÇƽʱҲ²»ÔÚÕâ³Ô£¬Ö»ÔÚÅàѵÆÚ¼äÏíÊÜÕâÑùµÄ´ýÓö£¬ÕâÀïƽ³£ÊÇÁìµ¼¼¶±ðµÄÑçϯ¡£ÆäÖÐÒ»¸öÄêÇáµÄ¾¯¹Ù£¬½ÐÔø¹ÚУ¬ÅàѵÍêºóÎÒÃÇ»¹»¥ÁôÁËÁªÏµ·½Ê½£¬ºÍÎÒ̸ÆðÁËÏã¸ÛµÄÁ®Õþ¹«Êð¡£¾Ý˵Ïã¸ÛµÄ¹«ÎñÔ±ºÜÉÙ·¢ÉúÖ°Îñ·¸×ÕâºÍËûÃÇÓÐÒ»¸ö¶ÀÁ¢µÄ¼à¹Ü»ú¹¹-Á®Õþ¹«Êð·Ö²»¿ª,Ò»µ©Ïã¸ÛµÄ¹«ÎñÔ±Óз¸×ï¼Ç¼£¬ÔòËûÃÇËùÓеÄÍËÐݺóÒ»Çи£Àû(ÍËÐݽð£¬ÑøÀϽðµÈ)½«±»°þ¶á£¬¶øÕâЩ¸£Àû¶ÔËûÃǺÜÖØÒª£¬×ã¹»ËûÃÇÍËÐݺó¼ÒÍ¥¹ýÉÏÏ൱ÓÅÔ£µÄÉú»î£¬ËùÒÔ£¬Ïã¸ÛµÄ¹«ÎñÔ±ºÜÉÙ»áȥðÕâ¸ö·çÏÕÈ¥½øÐÐÌ°ÎÛäÂÖ°µÈ·¸×ï¡£ÕâºÍмÓƵē¸ßнÑøÁ®”ËƺõÓÐÒìÇúͬ¹¤Ö®Ã²»¹ýÔڴ󽣬ÎÒÏàÐŻᱻ“Ò컯”£¬ÊÂʵÉÏ£¬Ðí¶àÔÚÈ«ÊÀ½çÖ¤Ã÷ÊǺܺõÄÖƶȻòÌåÖÆ£¬ÒýÈëµ½Öйú£¬ÍùÍùûÓз¢ÉúÔ¤ÆÚµÄЧ¹û¡£
ºÇºÇ£¬ÕâÊdz¶Ïл°ÁË¡£×÷ΪITÈËÊ¿£¬Ò²Ö»ÊǺÍËûÃÇËæ±ãÁÄÁÄ£¬ÔÛÒ²²»ÔÚÐС£ÓÉÓÚʱ¼ä»¹Ô磬ÎÒÃǼ


Ïà¹ØÎĵµ£º

²»ÊÇORACLEµÄÎÊÌâ

                                          ²»ÊÇORACLEµÄÎÊÌâ
2009-12-30 15:00
    ......

oracle Òƶ¯¸ßˮλ£º

²é¿´±íµÄ´óС£»
select a.blocks,a.bytes,a.bytes/1024/1024 from user_segments a
where a.segment_name='B_M_DZYH_CUST_SIGN_FACT';
Ê×ÏÈ
create table TEST_1228 as select * from user_tables;
insert into TEST_1228  select * from TEST_1228 ;
insert into TEST_1228  select * from TEST_1228 ;
i ......

Oracle 11g ÐÂÌØÐÔ¼ò½é

 
Oracle 11gÓÚ2007Äê7ÔÂ11ÈÕÃÀ¹ú¶«²¿Ê±¼ä11ʱ£¨±±¾©Ê±¼ä11ÈÕ22ʱ£©Õýʽ·¢²¼£¬11gÊǼ׹ÇÎĹ«Ë¾30ÄêÀ´·¢²¼µÄ×îÖØÒªµÄÊý¾Ý¿â°æ±¾£¬¸ù¾ÝÓû§µÄÐèÇóʵÏÖÁËÐÅÏ¢ÉúÃüÖÜÆÚ¹ÜÀí£¨Information Lifecycle Management£©µÈ¶àÏС£ 
 
Ò»£®ÐÂÌØÐÔÌá¸Ù
 
1.Êý¾Ý¿â¹ÜÀí²¿·Ö
¡ôÊý¾Ý¿âÖØÑÝ(Database Replay)&nb ......

oracle %type

1¡¢Ê¹ÓÃ%TYPE
ÔÚÐí¶àÇé¿öÏ£¬PL/SQL±äÁ¿¿ÉÒÔÓÃÀ´´æ´¢ÔÚÊý¾Ý¿â±íÖеÄÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬±äÁ¿Ó¦¸ÃÓµÓÐÓë±íÁÐÏàͬµÄÀàÐÍ¡£ÀýÈ磬students±íµÄfirst_nameÁеÄÀàÐÍΪVARCHAR2(20),ÎÒÃÇ¿ÉÒÔ°´ÕÕÏÂÊö·½Ê½ÉùÃ÷Ò»¸ö±äÁ¿
DECLARE
v_FirstName VARCHAR2(20);
µ«ÊÇÈç¹ûfirst_nameÁеĶ¨Òå¸Ä±äÁ˻ᷢÉúʲô£¨±ÈÈç˵±í¸Ä±äÁË£¬first ......

oracle %type

1¡¢Ê¹ÓÃ%TYPE
ÔÚÐí¶àÇé¿öÏ£¬PL/SQL±äÁ¿¿ÉÒÔÓÃÀ´´æ´¢ÔÚÊý¾Ý¿â±íÖеÄÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬±äÁ¿Ó¦¸ÃÓµÓÐÓë±íÁÐÏàͬµÄÀàÐÍ¡£ÀýÈ磬students±íµÄfirst_nameÁеÄÀàÐÍΪVARCHAR2(20),ÎÒÃÇ¿ÉÒÔ°´ÕÕÏÂÊö·½Ê½ÉùÃ÷Ò»¸ö±äÁ¿
DECLARE
v_FirstName VARCHAR2(20);
µ«ÊÇÈç¹ûfirst_nameÁеĶ¨Òå¸Ä±äÁ˻ᷢÉúʲô£¨±ÈÈç˵±í¸Ä±äÁË£¬first ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ