on 10-11-2008 6:12 PM
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
HI,
problem is resolved by using brspace -u / -f tbreorg -t "*" -a cleanup run then restarting reorganization
Thanks for help
Dinesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.