Today i was refreshing a MVIEW (Oracle 9.2.0.1.0 on Windows 2000) and instead of writing

[sql]exec dbms_mview.refresh(‘SCHEMA1.MVIEW1’,‘C’); [/sql]

i wrote

[sql]exec dbms_mview.refresh(‘SCHEMA1’,‘MVIEW1’,‘C’);[/sql]

And it gave me:

ERROR at line 1:

ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 794

ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 851

ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 832

ORA-06512: at line 1

[sql]ERROR at line 1: ORA-30019: Illegal rollback Segment operation in Automatic Undo mode ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 794 ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 851 ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 832 ORA-06512: at line 1[/sql]

which has nothing to do with the real error. Take care !