| Query [message #75213] |
Wed, 17 July 2002 01:34 |
Farooque Sorathia
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
Hello,
I have created a materialized view test of a table
test in scott schema. test table in scott has snapshot log.
The Syntax used is as below
create materialized view test
build immediate
refresh force
as select * from scott.test;
while refreshing this mview
using dbms_mview.refresh('test'),
I am getting an error as under(previously it was working)
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 604
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 661
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 641
ORA-06512: at line 2
Kindly Help
Farooque S
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
