Database DataWarehousing (MOSC)

MOSC Banner

Materialized View problem

edited Dec 12, 2017 4:22PM in Database DataWarehousing (MOSC) 4 commentsAnswered

Hi,

I have a problem with MV. Sometimes in alert appears this error:

=============================================================

   Errors in file /usr/oracle/diag/rdbms/bbdd/bbdd/trace/bbdd_j003_32668.trc:

   ORA-10632: Invalid rowid

=============================================================

=============================================================

Trace file bbdd_j003_32668.trc :

Trace file /usr/oracle/diag/rdbms/bbdd/bbdd/trace/bbdd_j003_32668.trc

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Build label:    RDBMS_12.2.0.1.0_LINUX.X64_170125

ORACLE_HOME:    /usr/oracle/product/12.2.0.1

System name:    Linux

Node name:      PRUEBAS-BD

Release:        3.10.0-514.el7.x86_64

Version:        #1 SMP Wed Oct 19 11:24:13 EDT 2016

Machine:        x86_64

Instance name: bbdd

Redo thread mounted by this instance: 1

Oracle process number: 360

Unix process pid: 32668, image: oracle@PRUEBAS-BD (J003)

Tagged:

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