----采用预建表的方式创建物化视图,报ora-04020错误,请大牛们看看,怎么破,具体如下:SQL> create table t_mv
2 (
3 a number,
4 b number,
5 constraint pk_t_mv_a primary key(a)
6 );Table createdSQL>
SQL> insert into t_mv values(1,1);1 row insertedSQL> insert into t_mv values(2,2);1 row insertedSQL> commit;Commit completeSQL> create materialized view log on t_mv with primary key;Materialized view log createdSQL>
SQL> create materialized view t_mv
2 on prebuilt table
3 refresh force on demand
4 as
5 select * from t_mv;create materialized view t_mv
on prebuilt table
refresh force on demand
as
select * from t_mvORA-04020: 尝试锁定对象 30x8E3CC2D80x869BDFC40x8FFAB124 时检测到死锁----drop table t_mv;
----drop materialized view log on t_mv;[/size]
2 (
3 a number,
4 b number,
5 constraint pk_t_mv_a primary key(a)
6 );Table createdSQL>
SQL> insert into t_mv values(1,1);1 row insertedSQL> insert into t_mv values(2,2);1 row insertedSQL> commit;Commit completeSQL> create materialized view log on t_mv with primary key;Materialized view log createdSQL>
SQL> create materialized view t_mv
2 on prebuilt table
3 refresh force on demand
4 as
5 select * from t_mv;create materialized view t_mv
on prebuilt table
refresh force on demand
as
select * from t_mvORA-04020: 尝试锁定对象 30x8E3CC2D80x869BDFC40x8FFAB124 时检测到死锁----drop table t_mv;
----drop materialized view log on t_mv;[/size]
解决方案 »
- CREATE OR REPLACE VIEW YOSANN_HZ 速度特别慢
- oracle表连接的原理?
- oracle基础
- 一张表里面进行比对查询,有点烦
- 见到论坛上这么多人说[马甲马甲],[马甲]是什么意思啊?
- 如何编写触发器向另外一个数据库写数据
- 急:sequence跳跃问题
- ORA-01455:转换列溢出整数数据类型
- 为什么FORM BULIDER总是不能连接数据库
- 在表中有一字段长度为Varchar2(20),但却只能输入10个中文字符!可输入20个英文字符!如何能该字段容纳20个中文字符!急急急!请大侠帮忙
- oracle中为什么调用存储过程在表中插入一条数据时,实际插入了两条
- oracle行和列如何转换?
SELECT object_name, machine, s.sid, s.serial#
FROM gv$locked_object l, dba_objects o, gv$session s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid;
杀掉死锁
ALTER system kill session 'sid的值, serial#的值';