Oracle UNDO块
发布时间:2021-03-10 02:43:43 所属栏目:站长百科 来源:网络整理
导读:副标题#e# ?1)首先更新几条数据,但是不进行commit如下: [email?protected] prodselect * from scott.emp;EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO---------- ---------- --------- ---------- ------------------- ---------- ---------- --------
可以先查询出object_id,在trace文件中搜索 [email?protected] prod>col object_name for a20 [email?protected] prod>select OBJECT_NAME,OBJECT_ID,OBJECT_TYPE,CREATED from dba_objects where OBJECT_name = ‘EMP‘; OBJECT_NAME OBJECT_ID OBJECT_TYPE CREATED -------------------- ---------- ------------------- ------------------- EMP 73181 TABLE 2009-08-13 23:35:45? (编辑:PHP编程网 - 湛江站长网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
站长推荐