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
 
Ïà¹ØÎĵµ£º
1.ÔÚORACLEÖÐʵÏÖ·Ö²¼Ê½¿ìËÙ´æÈ¡ºÍ³äʵÄÚ´æÊǺÜÖØÒªµÄ¡£
¡¡¡¡
¡¡¡¡Òª²»Ï§Èκδú¼Û±ÜÃâÒ³Ãæµ÷¶ÈºÍ½»»»﹐ÿ´Î¶¼±ØÐë°Ñϵͳȫ¾ÖÇø(SGA)·Åµ½ÄÚ´æ¡£
¡¡¡¡
¡¡¡¡½«SGA·Åµ½ÄÚ´æÖÐ﹐ÔÚINIT.ORAÖÐÉèÖòÎÊý PRE_PAGE_SGA
¡¡¡¡
¡¡¡¡PRE_PAGE_SGA=YES
¡¡¡¡
¡¡¡¡2.»Ø¾í¶ÎµÄ¾¹Õù»á½µµÍϵͳµÄÐÔÄÜ¡£
¡¡¡¡
¡¡¡¡SELECT¡ ......
³£ÓÃ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ÖеÄBLOB×Ö¶ÎÊÇ´æ´¢2½øÖƵÄÎļþ£¬±ÈÈçÎļþ£¬Í¼Æ¬µÈ¡£
1¡¢°Ñ±¾µØÎļþдÈëÊý¾Ý¿â
package com.data;
import java.io.File;
import java.io.FileInputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.R ......
protected void BindData1()
{
OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
orcn.Open();
&nb ......
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......