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
Ïà¹ØÎĵµ£º
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/cosio/archive/2009/03/11/3978747.aspx
ÓÐÁ½ÖÖº¬ÒåµÄ±í´óС¡£Ò»ÖÖÊÇ·ÖÅä¸øÒ»¸ö±íµÄÎïÀí¿Õ¼äÊýÁ¿£¬¶ø²»¹Ü¿Õ¼äÊÇ·ñ±»Ê¹Ó᣿ÉÒÔÕâÑù²éѯ»ñµÃ×Ö½ÚÊý£º
select segment_name, bytes
from user_segments
where segment_type = 'TABLE';
»òÕß
Sel ......
¿ÉǨÒƱí¿Õ¼ätransport tablespace
¿ÉǨÒƱí¿Õ¼ä
ʹÓÿÉǨÒƱí¿Õ¼ä(Transportable Tablespaces)µÄÌØÐÔÔÚÊý¾Ý¿âÖ®¼äÒƶ¯´óÁ¿Êý¾Ý£¬ÐÔÄܱÈexport/importºÍunload/loadÒª¿ìºÜ¶à£¬ÒòΪËüǨÒƱí¿Õ¼äÖ»ÐèÒª¸´ÖÆÊý¾ÝÎļþºÍ²åÈë±í¿Õ¼äÔªÊý¾Ýµ½Ä¿±êÊý¾Ý¿âÖС£
ǨÒƱí¿Õ¼ä¶ÔÒÔÏÂÓ¦ÓÃÌرðÓÐÓãº
·Ö½×¶Î½«OLTPµÄÊý¾ÝÒÆÈëÊý¾Ý²Ö¿â
¸ ......
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ÖУ¬ÎÒÃÇ´´½¨Ò»¸öÖ÷¼ü£¬Ôòͬʱ×Ô¶¯´´½¨ÁËÒ»¸öͬÃûµÄΨһË÷Òý£»É¾³ýÖ÷¼ü£¬ÔòÖ÷¼üÔ¼ÊøºÍ¶ÔÓ¦µÄΨһË÷Òý¶¼É¾³ýÁË¡£ÕâÊÇÎÒÃǾ³£¼ûµ½µÄÏÖÏó¡£
·¢³öÒ»¸ö´´½¨Ö÷¼üµÄsql£¬oracleÆäʵִÐÐÁËÁ½²½£º´´½¨Ö÷¼üÔ¼Êø¡¢´´½¨/¹ØÁª ΨһË÷Òý¡£²½ÖèÊÇÕâÑùµÄ£º
´´½¨Ö÷¼üÔ¼Êøʱ£¬¼ì²é¸ÃÖ÷¼ü×Ö¶ÎÉÏÊÇ·ñÒѾ´æÔÚΨһË÷Òý¡£Èô² ......