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

OracleÉó¼Æ¹¦ÄÜ

OracleÉó¼Æ¹¦ÄÜ
Ò»¡¢    Éó¼Æ·ÖÀࣺ
OracleÖÐÉó¼Æ×ÜÌåÉÏ¿É·ÖΪ“±ê×¼Éó¼Æ”ºÍ“ϸÁ£¶ÈÉó¼Æ”ºóÕßÒ²³ÆΪ“»ùÓÚÕþ²ßµÄÉó¼Æ”£¬ÔÚOracle10GÖ®ºó¹¦Äܵõ½ºÜ´óÔöÇ¿¡£ÆäÖбê×¼Éó¼Æ¿É·ÖΪÓû§¼¶Éó¼ÆºÍϵͳ¼¶Éó¼Æ¡£Óû§¼¶Éó¼ÆÊÇÈκÎOracleÓû§¿ÉÉèÖõÄÉó¼Æ£¬Ö÷ÒªÊÇÓû§Õë¶Ô×Ô¼º´´½¨µÄÊý¾Ý¿â±í»òÊÓͼ½øÐÐÉó¼Æ£¬¼Ç¼ËùÓÐÓû§¶ÔÕâЩ±í»òÊÓͼµÄÒ»Çгɹ¦ºÍ(»ò)²»³É¹¦µÄ·ÃÎÊÒªÇóÒÔ¼°¸÷ÖÖÀàÐ͵ÄSQL²Ù×÷¡£ÏµÍ³¼¶Éó¼ÆÖ»ÄÜÓÉDBAÉèÖã¬ÓÃÒÔ¼à²â³É¹¦»òʧ°ÜµÄµÇ¼ҪÇó¡¢¼à²âGRANTºÍREVOKE²Ù×÷ÒÔ¼°ÆäËûÊý¾Ý¿â¼¶È¨ÏÞϵIJÙ×÷¡£
¶þ¡¢    ±ê×¼Éó¼Æ£º
2.1 ·ÖÀࣺ
ÔÚORACLEÖзֱðÖ§³ÖÒÔÏÂÈýÖÖ±ê×¼Éó¼ÆÀàÐÍ£º
u          Óï¾äÉó¼Æ£¬¶ÔijÖÖÀàÐ͵ÄSQLÓï¾äÉó¼Æ£¬²»Ö¸¶¨½á¹¹»ò¶ÔÏó¡£
u          ÌØȨÉó¼Æ£¬¶ÔÖ´ÐÐÏàÓ¦¶¯×÷µÄϵͳÌØȨµÄʹÓÃÉó¼Æ¡£
u          ¶ÔÏóÉó¼Æ£¬¶ÔÒ»ÌØÊâģʽ¶ÔÏóÉϵÄÖ¸¶¨Óï¾äµÄÉó¼Æ¡£
ÕâÈýÖÖ±ê×¼Éó¼ÆÀàÐÍ·Ö±ð¶ÔÈçÏÂ3·½Ãæ½øÐÐÉó¼Æ£º
u          Éó¼ÆÓï¾äµÄ³É¹¦Ö´ÐС¢²»³É¹¦Ö´ÐУ¬»òÕßÆäÁ½Õß¡£
u          ¶ÔÿһÓû§»á»°Éó¼ÆÓï¾äÖ´ÐÐÒ»´Î»òÕ߶ÔÓï¾äÿ´ÎÖ´ÐÐÉó¼ÆÒ»´Î¡£
u          ¶ÔÈ«²¿Óû§»òÖ¸¶¨Óû§µÄ»î¶¯µÄÉó¼Æ¡£
     µ±Êý¾Ý¿âµÄÉó¼Æ¹¦ÄÜ´ò¿ªºó£¬ÔÚÓï¾äÖ´Ðн׶βúÉúÉó¼Æ¼Ç¼¡£Éó¼Æ¼Ç¼°üº¬ÓÐÉó¼ÆµÄ²Ù×÷¡¢Óû§Ö´ÐеIJÙ×÷¡¢²Ù×÷µÄÈÕÆÚºÍʱ¼äµÈÐÅÏ¢¡£Éó¼Æ¼Ç¼¿É´æÔÚÊý¾Ý×Öµä±í£¨³ÆΪÉó¼Æ¼Ç¼£©»ò²Ù×÷ϵͳÉó¼Æ¼Ç¼ÖС£Êý¾Ý¿âÉó¼Æ¼Ç¼ÊÇÔÚSYSģʽµÄAUD$±íÖС£
2.2ÉèÖÃORACLE±ê×¼Éó¼Æ£º
ÏÂÁв½Öè¿ÉÒÔÉèÖÃORACLEµÄ±ê×¼Éó¼Æ¹¦ÄÜ£º
1.    Ð޸ijõʼ»¯²ÎÊýÎļþ£¨init<sid>.ora£©
Èç¹ûʹÓ÷þÎñÆ÷²ÎÊýÎļþʹÓÃalter system set <parameter>=<value> scope=spfile|both£¬ÏêÇé²ÎÕÕ1.1½ÚÖйØÓÚ²ÎÊýÎļþµÄ½éÉÜ£©£¬ÉèÖà AUDIT_TRAIL²ÎÊý£¬²¢ÇÒÖØÆôÊý¾Ý¿â¡£AUDIT_TRAILµÄÈ¡ÖµÈçÏ£º
l         DB/TRUE£ºÆô¶¯Éó¼Æ¹¦ÄÜ£¬²¢ÇÒ°ÑÉó¼Æ½á¹û´æ·ÅÔÚÊý¾Ý¿âµÄ SYS.AUD$ ±íÖÐ
l     &nb


Ïà¹ØÎĵµ£º

OracleÖвéѯ±íµÄ´óСºÍ±í¿Õ¼äµÄ´óС

±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/cosio/archive/2009/03/11/3978747.aspx
ÓÐÁ½ÖÖº¬ÒåµÄ±í´óС¡£Ò»ÖÖÊÇ·ÖÅä¸øÒ»¸ö±íµÄÎïÀí¿Õ¼äÊýÁ¿£¬¶ø²»¹Ü¿Õ¼äÊÇ·ñ±»Ê¹Ó᣿ÉÒÔÕâÑù²éѯ»ñµÃ×Ö½ÚÊý£º
select segment_name, bytes
from user_segments
where segment_type = 'TABLE';
»òÕß
   Sel ......

oracleǨÒƱí¿Õ¼ä

¿ÉǨÒƱí¿Õ¼ätransport tablespace
¿ÉǨÒƱí¿Õ¼ä
ʹÓÿÉǨÒƱí¿Õ¼ä(Transportable Tablespaces)µÄÌØÐÔÔÚÊý¾Ý¿âÖ®¼äÒƶ¯´óÁ¿Êý¾Ý£¬ÐÔÄܱÈexport/importºÍunload/loadÒª¿ìºÜ¶à£¬ÒòΪËüǨÒƱí¿Õ¼äÖ»ÐèÒª¸´ÖÆÊý¾ÝÎļþºÍ²åÈë±í¿Õ¼äÔªÊý¾Ýµ½Ä¿±êÊý¾Ý¿âÖС£
ǨÒƱí¿Õ¼ä¶ÔÒÔÏÂÓ¦ÓÃÌرðÓÐÓãº
·Ö½×¶Î½«OLTPµÄÊý¾ÝÒÆÈëÊý¾Ý²Ö¿â
¸ ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨ ¼°×¢ÒâÊÂÏî

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨ ¼°×¢ÒâÊÂÏî
oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«selec ......

oracle Ö÷¼ü \Ë÷Òý


ÔÚoracleÖУ¬ÎÒÃÇ´´½¨Ò»¸öÖ÷¼ü£¬Ôòͬʱ×Ô¶¯´´½¨ÁËÒ»¸öͬÃûµÄΨһË÷Òý£»É¾³ýÖ÷¼ü£¬ÔòÖ÷¼üÔ¼ÊøºÍ¶ÔÓ¦µÄΨһË÷Òý¶¼É¾³ýÁË¡£ÕâÊÇÎÒÃǾ­³£¼ûµ½µÄÏÖÏó¡£
 
·¢³öÒ»¸ö´´½¨Ö÷¼üµÄsql£¬oracleÆäʵִÐÐÁËÁ½²½£º´´½¨Ö÷¼üÔ¼Êø¡¢´´½¨/¹ØÁª ΨһË÷Òý¡£²½ÖèÊÇÕâÑùµÄ£º
´´½¨Ö÷¼üÔ¼Êøʱ£¬¼ì²é¸ÃÖ÷¼ü×Ö¶ÎÉÏÊÇ·ñÒѾ­´æÔÚΨһË÷Òý¡£Èô² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ