- 博客(8)
- 资源 (13)
- 收藏
- 关注
原创 Flashback
test@ORCL>exec :scn := dbms_flashback.get_system_change_numberPL/SQL procedure successfully completed.test@ORCL>print scn SCN---------- 682621test@ORCL>select count(*) from emp; COUNT(*)---------- 14test@ORCL>delete from emp;14 rows deleted.test@
2011-02-26 12:53:00 376
原创 SQL TRACE File Locations
Whether you use SQL_TRACE or the extended trace facility, Oracle will start generating a tracefile on the database server machine in one of two locations:• If you are using a dedicated server connection, the trace file will be generated in thedirectory spe
2011-02-23 22:17:00 274
原创 Bitmap index block concurrence
test@ORCL>create table t(processed_flag varchar2(1));Table created.test@ORCL>create bitmap index t_idx on t(processed_flag);Index created.Create a bitmap index on table t;test@ORCL>insert into t values('N');1 row created.Insert value 'N' into table t at on
2011-02-19 21:37:00 284
原创 Defining Database and Instance
<br />Database: A collection of physical operating system files(data files,temporary files,redo log files,control files) or disk.<br />Instance: A set of Oracle background processes/threads and a shared memory area,which is memory that is shared across tho
2011-02-19 01:12:00 269
原创 无法串行访问事务错误:ORA-08177: can't serialize access for this transaction
<br />当事务隔离级别为serializable,两个事务并发修改同一个对象,当前一个事务提交或回滚时,第二个事务会收到该错误。<br /> <br />测试使用表,此表用于生成唯一主键:<br /> <br />test@ORCL> create table id_table<br /> 2 (id_name varchar2(30) primary key,<br /> 3 id_value number);<br />Table created.<br /> <br />test@ORCL
2011-02-18 21:32:00 5157
原创 闪回命令出错 ORA-08189: cannot flashback the table because row movement is not enabled
<br />test@ORCL>flashback table t to scn:scn<br /> 2 ;<br />flashback table t to scn:scn<br /> *<br />ERROR at line 1:<br />ORA-08189: cannot flashback the table because row movement is not enabled<br /> <br />使用闪回命令出错<br /> <br /> <br />
2011-02-17 21:26:00 7422
原创 ORACLE创建视图提示ORA-01031: insufficient privileges
<br />create or replace view stats as select 'STAT...' || a.name name,b.value <br />from v$statname a, v$mystat b <br />where a.STATISTIC# = b.STATISTIC# <br />union all select 'LATCH.'|| name,gets from v$latch;<br /> <br /> <br />ORA-01031: insufficient p
2011-02-16 20:44:00 5315
druid-mysql demo
2016-09-03
使用 VMware Server 在 Oracle Enterprise Linux 上安装 Oracle RAC 10g
2011-05-11
Redhat 5.4安装oracle 9.2.0.4补丁和RPM包(二)
2010-08-15
Redhat Enterprice 5.4 安装oracle 9.2.0.4补丁和RPM包(一)
2010-08-15
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人