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

oracle ´¥·¢Æ÷¿ª·¢

 ´¥·¢Æ÷¿ª·¢µÄÄ¿µÄ£ºÈ·±£Êý¾Ý¿âÂú×ãÌØ¶¨µÄÉÌÒµ¹æÔòºÍÆóÒµÂß¼­£¬¿ÉÒÔʹÓô¥·¢Æ÷£¬Ô¼Êø£¬×Ó³ÌÐò¡£ÒòΪ
   Ô¼Êø×î¼òµ¥ÇÒÐÔÄܺã¬ËùÑ¡Ô¼Êø£¬Èç¹ûÔ¼Êø²»ÄÜÂú×㣬¾ÍÓô¥·¢Æ÷£¬Èô´¥·¢Æ÷¶¼²»ÄÜÂú×ãÑ¡Ôñ×Ó³ÌÐò¡£
  
   Ò»¡¢´¥·¢Æ÷¹¦ÄÜ£º
   1£¬¿ØÖÆÊý¾Ý°²È«,ÔÚ·þÎñÆ÷¼¶±ð¿ØÖÆÊý¾Ý°²È«ÊÇͨ¹ýÊÚȨºÍ»ØÊÕ¶ÔÏóȨÏÞÀ´Íê³ÉµÄ£¬±ÈÈçamsÓû§¶Ôscott/tiger Óû§¶Ô±íDML ²Ù×÷¡¢
   grant select ,delete,update,insert on emp to ams;
   µ«ÊÇΪÁËʵÏÖ¸ü¸´Ôӵݲȫģʽ£¬±ÈÈçÏÞÖÆ¶Ôij¸ö±íÒªÐ޸ĵÄÊý¾Ý£¬¾ÍÐèÒªÓõ½´¥·¢Æ÷£¬±ÈÈ磬ֻÓÐÔÚ9£º00µ½17£º00²ÅÄܸıäÊý¾Ý¿âEMP±í¶ÔÊý¾Ý¿â±í²Ù×÷
   create or replace trigger triger_stat_before
    before insert or update or delete on emp
    
    declare
    -- local variables here
    begin
     if (to_char(sysdate,'HH24') not between '9' and '17') then
       RAISE_APPLICATION_ERROR(-20101,'·Ç¹¤×÷ÈÕʱ¼ä');
     end if;
   end triger_before;
   2£¬ÊµÏÖÊý¾ÝÉ󼯣¬¼àÊÓ·Ç·¨ºÍ¿ÉÒɵÄÊý¾Ý»î¶¯£¬oracle ±¾ÉíÌṩÁËÉ󼯹¦ÄÜ¡£Èç¶Ôemp DML ²Ù×÷ÒÔºó£¬
   °ÑSQL²Ù×÷µÄÐÅÏ¢(Óû§£¬Ê±¼äµÈ)дÈë×ֵ䡣µ«ÊÇÖ»ÄÜÉó¼Æsql ²Ù×÷£¬²»ÄܼÇÔØÊý¾Ý±ä»¯¡£Èç¹ûÒª¼ÇÔØÊý¾Ý
   ±ä»¯±ØÐëʹÓÃDML´¥·¢Æ÷¡£±ÈÈ繤×ʱ仯дÈëÊý¾Ý×Öµä±í¡£
   --´´½¨×Öµä±í
      drop table EMP_CHANGE;
   create table EMP_CHANGE(
    CNAME       VARCHAR2(200),
    OLDSAL      NUMBER,
    NEWSAL      NUMBER,
    CHANGE_TIME TIMESTAMP(6)
   )
  --´´½¨´¥·¢Æ÷
  create or replace trigger triger_row_after
   after update of sal  on emp 
   for each row
 


Ïà¹ØÎĵµ£º

OracleÓû§±í¿Õ¼ä±¦µä

Oracle»¹ÊDZȽϳ£Óõģ¬ÓÚÊÇÎÒÑо¿ÁËÒ»ÏÂOracleÓû§±í¿Õ¼ä£¬ÔÚÕâÀïÄóöÀ´ºÍ´ó¼Ò·ÖÏíһϣ¬Ï£Íû¶Ô´ó¼ÒÓÐÓá£ÔÚÎÒÃÇΪ΢ÈíµÄNTFS·ÖÇø¸ñʽÖеÄÓû§´ÅÅÌÅä¶î¹ÄÕÆµÄʱºò£¬OracleÊý¾Ý¿âÖÐÒ²ÒѾ­ÊµÏÖÁËÓû§´ÅÅÌÅä¶îµÄ¼¼Êõ¡£¿ÉÒÔ½èÖú±í¿Õ¼ä£¬À´¶ÔÓû§½øÐдÅÅÌÅä¶î¹ÜÀí¡£ÀûÓñí¿Õ¼äµÄÓû§´ÅÅÌÅä¶î£¬¿ÉÒÔʵÏֺܶ๦ÄÜ¡£
Èç¿ÉÒÔÀûÓÃÓà ......

oracle³£Óþ­µäSQL²éѯ£¨×ªÔØ£©

³£ÓÃSQL²éѯ£º
1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
from dba_tablespaces t, dba_data_files d
where t.tablespace_name = d.tablespace_name
group by t.tablespace_name;
2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ¼°´óС
select tablespace_name, file_id, ......

OracleÖйúCEOºú²®ÁÖ£º¹ÜÀí¾ÍÊǹµÍ¨

¶Ôºú²®ÁֵIJɷÃÈçÆÚÔÚλÓÚ±±¾©¹úóµÄOracleÖйú×ܲ¿½øÐУ¬µ±¼ÇÕß°Ñ×¼±¸ºÃµÄ²É·ÃÌá¸ÙµÝ¸øºú²®ÁÖÖ⣬ÒÔΪËû»áÏñÐí¶àÊÜ·ÃÕßÒ»ÑùÌÏÌϲ»¾øÆðÀ´£¬Ë­ÖªËûÖ»ÊÇ¿´ÁËÒ»ÑÛ˵£º“»¹ÊÇÒ»ÆðÌÖÂÛ°É£¬Îҿɲ»Ô¸³ª¶À½ÇÏ·¡£”
¡¡¡¡ÔÚOracleÖйú£¬ºú²®ÁÖÊÇÒ»¸öÇÅÁº£¬Ò»¸öÓë×ܲ¿ÓëÖйúÔ±¹¤Ö®¼ä¹µÍ¨µÄÇÅÁº£¬Ò»¸öÕ½ÂÔÖÆ¶¨ÓëÖ´ÐÐÖ®¼äµÄÇÅ ......

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ