Mview refresh failing due to ORA-1628: error
Our's is an Oracle 9i database but the undo management is manual. The rollback segment configuration in the database is as below:
SEGME OWNER TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE STATUS
----- ------ --------------- -------------- ----------- ----------- ----------- ------------ ----------------
SYSTEM SYS SYSTEM 57344 1048576 2 121 0 ONLINE
R01 SYS RBS 106496 106496 10 32765 0 ONLINE
R02 SYS RBS 106496 106496 10 32765 0 ONLINE
R03 SYS RBS 106496 106496 10 32765 0 ONLINE
R04 SYS RBS 106496 106496 10 32765 0 ONLINE
R05 SYS RBS 106496 106496 10 32765 0 ONLINE
R06 SYS RBS 106496 106496 10 32765 0 ONLINE
R07 SYS RBS 106496 106496 10 32765 0 ONLINE
R08 SYS RBS 106496 106496 10 32765 0 ONLINE
R09 SYS RBS 106496 106496 10 32765 0 ONLINE
10 rows selected.
We are trying to refresh a mview in this database. The base tbale is approx 11gb in size. The refresh is successfully reading the data from the base table and then it starts the sort output on the local database. During that time, the refresh fails with the below error :