SOFFCONT1 table reorganization error

[akash_ahuja]

HI,

We have 1.5 TB SOFFCONT1 table which is having log segment and want to

reduce the size and run reports as suggested by SAP Notes but not able

toreorg the same due to error while doing reorg by BRTOOLS.

I have run the following command:-

brspace -u / -c force -f tbreorg -a reorg -o SAPRP1 -s PSAPRP1 -t

SOFFCONT1 -n PSAPRP1SOFF -e 16 -KST

Ouutput error:-

BR0280I BRSPACE time stamp: 2014-07-04 19.43.41

BR1101I Starting 'online' table reorganization...

BR0280I BRSPACE time stamp: 2014-07-04 19.43.42

BR1124I Starting 'online' reorganization of table SAPRP1.SOFFCONT1 ...

BR0280I BRSPACE time stamp: 2014-07-04 19.44.03

BR0301E SQL error -42008 at location tab_onl_reorg-39, SQL statement:

'BEGIN DBMS_REDEFINITION.START_REDEF_TABLE (UNAME => '"SAPRP1"',

ORIG_TABLE => '"SOFFCONT1"', INT_TABLE => '"SOFFCONT1#$"', OPTIONS_FLAG

=> DBMS_REDEFINITION.CONS_USE_PK); END;'

ORA-42008: error occurred while instantiating the redefinition

ORA-01405: fetched column value is NULL

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

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

ORA-06512: at line 1

BR0280I BRSPACE time stamp: 2014-07-04 19.44.05

BR1106E Reorganization of table SAPRP1.SOFFCONT1 failed

This is not specific to the table i have also upgrade the BRTOOLS but

issue not getting resolved still same error coming.

please suggest.

Regards:

Akash Ahuja

[akash_ahuja · Accepted solution]

Hi All,

This problem has been resolved after applying the Latest SBP, The problem was oracle DBMS_REDEFINITION package which resolved after applying the bundle patch.

Thanks for reply.

Regards:

Akash Ahuja

[Former Member · Accepted solution]

Dear All

I have the same problem , and my problem resolved after executing  /oracle/<SID>/112_64/rdbms/admin/catalog.sql

This script might have been forgot to execute during base installation of sap database.

Regards

Harish

[stefan_koehler]

Hi Akash,

what is your exact Oracle version? I already replied to the same issue in a different thread here:

Oracle/SAP also published a patch for this bug #13767921 - for more information check SAPnote #1525681.

Regards

Stefan

[former_member188883]

Hi Akash,

For your error message you can set the event parameter as suggested in SAP note below

Note 1290097 - ORA-01792 while running online reorganization of the table

Hope this helps.

Regards,

Deepak Kori

[former_member182657]

Hi Ahuja,

Kindly follow SAP Note  1290097 - ORA-01792 while running online reorganization of the table

Regards,

Gaurav

[akash_ahuja]

I already check this Note but still the same error.

[ImtiazKaredia]

Hi,

This table contains LOB field, this could be the cause.

Can you check 1431296 - LOB conversion and table compression with BRSPACE 7.20 and check if it helps.

Thanks

Imtiaz