Database DataWarehousing (MOSC)

MOSC Banner

Mview refresh failing due to ORA-1628: error

edited Jun 9, 2011 4:37PM in Database DataWarehousing (MOSC) 5 commentsAnswered
 Hi,

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 :

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center