https://blog.youkuaiyun.com/dream_1986zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/dream_1986/article/details/6220538https://blog.youkuaiyun.com/dream_1986/article/details/6220538dream_1986Thu, 03 Mar 2011 13:57:00 +0800CREATE OR REPLACE TRIGGER BI_M_OUT_HITEM
    INSTEAD OF INSERT OR UPDATE OR DELETE ON M_OUT_HITEM REFERENCES OLD AS OLD NEW AS NEW
    FOR EACH ROW
DECLARE
        v_boxstatus               NUMBER(10);
        v_isb]]>https://blog.youkuaiyun.com/dream_1986/article/details/6042798https://blog.youkuaiyun.com/dream_1986/article/details/6042798dream_1986Mon, 29 Nov 2010 14:48:00 +0800Today I will be master of my emotions.
The tides advance; the tides recede. Winter goes and summer comes. summer wanes and the cold increases. The sun rises; the sun sets. The moon is full; the moon is black. The birds arrive;the birds depart]]>https://blog.youkuaiyun.com/dream_1986/article/details/6042754https://blog.youkuaiyun.com/dream_1986/article/details/6042754dream_1986Mon, 29 Nov 2010 14:35:00 +08001、连接到目标数据库(不用恢复目录数据库)：
      Rman nocatalog target sys/change_on_isntall@testdb
      Rman catalog rman_user/rman_user@ora9rc target sys/change_on_install@testdb
2、SHOW命令：
      显示rman配置： RMAN> show all;
3、REPORT命令：]]>https://blog.youkuaiyun.com/dream_1986/article/details/6034485https://blog.youkuaiyun.com/dream_1986/article/details/6034485dream_1986Thu, 25 Nov 2010 13:10:00 +0800Microsoft Windows [版本 6.1.7600]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:/Users/Administrator>emca
d:/oracle/product/10.2.0/db_1/bin/emca.bat [操作] [模式] [数据库类型] [标记] [参
数]

-h | --h | -help | --help: ]]>https://blog.youkuaiyun.com/dream_1986/article/details/6000353https://blog.youkuaiyun.com/dream_1986/article/details/6000353dream_1986Wed, 10 Nov 2010 15:28:00 +0800Oracle高水位标志:    high-water mark
可以用以下几点对high-water mark进行理解
1.指一个表中曾经被用过的最后一个块
2.如果有数据被插入表，high-water mark 就移到到被使用的最后一个块
3.如果有数据被删除，high-water mark的位置不会变
4.high-water mark被储存在表的段头(segment header of the table)
5.当对表执行全]]>https://blog.youkuaiyun.com/dream_1986/article/details/5953910https://blog.youkuaiyun.com/dream_1986/article/details/5953910dream_1986Wed, 20 Oct 2010 12:57:00 +0800https://blog.youkuaiyun.com/dream_1986/article/details/4765721https://blog.youkuaiyun.com/dream_1986/article/details/4765721dream_1986Wed, 04 Nov 2009 09:06:00 +0800