Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 12, 2008 at 12:48 AM

    HI,

    problem is resolved by using brspace -u / -f tbreorg -t "*" -a cleanup run then restarting reorganization

    Thanks for help

    Dinesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Oct 11, 2008 at 06:44 PM

    Hello Dinesh,

    the pl/sql function DBMS_REDEFINITION.CAN_REDEF_TABLE is the first one in the online reorganization process. This step checks, if the table can be reorganized online.

    In your case you hit one of the limitations / restrictions of the online reorganization:

    http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#ADMIN01510

    For the explanation of the ORA error code:

    http://ora-12091.ora-code.com/

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 20, 2014 at 08:16 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded