Home » Server Options » Replication » Query
Query [message #75213] Wed, 17 July 2002 01:34
Farooque Sorathia
Messages: 1
Registered: July 2002
Junior Member
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
Previous Topic: Reg Snapshots
Next Topic: Replication of functions and views
Goto Forum:

Current Time: Tue Jul 14 22:19:55 CDT 2020