Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Errrore during oracle Database reorganization

HI friends,

we are running oracle Database reorganization with Brtools, we are on oracle 10.2 and brtools 7.0 patch 34, during Database reorganization we are getting issue errors as below, can some one help me please

BR0301W SQL error -12091 at location BrReorgCheck-5, SQL statement:

'BEGIN DBMS_REDEFINITION.CAN_REDEF_TABLE (UNAME => '"SAPR3"', TNAME => '"/BI0/XCAMPAIGN"', OPTIONS_FLAG => DBMS_REDEFINITION.CONS_USE_PK); END;'

ORA-12091: cannot online redefine table "SAPR3"."/BI0/XCAMPAIGN" with materialized views

ORA-06512: at "SYS.DBMS_REDEFINITION", line 137

ORA-06512: at "SYS.DBMS_REDEFINITION", line 1478

ORA-06512: at line 1

BR1111I Reorganization of table SAPR3./BI0/XCAMPAIGN will be skipped

BR0284I BRSPACE time stamp: 2008-10-12 05.39.35, elapsed time: 0:00

BR0301W SQL error -12091 at location BrReorgCheck-5, SQL statement:

'BEGIN DBMS_REDEFINITION.CAN_REDEF_TABLE (UNAME => '"SAPR3"', TNAME => '"/BI0/XCRM_MKTELM"', OPTIONS_FLAG => DBMS_REDEFINITION.CONS_USE_PK); END;'

ORA-12091: cannot online redefine table "SAPR3"."/BI0/XCRM_MKTELM" with materialized views

ORA-06512: at "SYS.DBMS_REDEFINITION", line 137

ORA-06512: at "SYS.DBMS_REDEFINITION", line 1478

Dinesh kumar

Former Member
Former Member replied

Refer to SAP note: 646681,

Remark 3

-


During the reorganization, Oracle creates some temporary objects, such as

Materialized-View Logs (MLOG$_<table>) or indexes that support ROWID

constraints (I_SNAP$_<table>#$), in the SAP user's (SAPR3 or SAP<SID>)

default tablespace (PSAPUSER1D oder PSAP<SID>USR). You therefore need to

make sure that there is enough free space in this tablespace. If necessary,

extend the tablespace for the duration of the reorganization or set the

tablespace to Auto Extend.

Also, setup the following enviroment variables to avoid termination errors:

setenv BR_MSL 10485760

setenv BR_DBL 41943040

Cheers,

Nisch

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question