SAP Knowledge Base Article - Preview

1831679 - Problems when doing online reorg of PCL2 table

Symptom

  • TablePCL2 has a long raw column. Using conversion from long 2 lob moving PCL2 table from dictionnary managed tablespace to locally managed tablespace (LMTS)
  • Command : brspace -f tbreorg -action long2lob -table SAPR3.PCL2 -newts PSAPBTAB14AD -indts PSAPBTAB14AI -parallel 1 -degree 1
  • Reorganization failed with the below error:-
  • BR0301E SQL error -42011 at location tab_onl_reorg-42, SQL statement: 'BEGIN DBMS_REDEFINITION.FINISH_REDEF_TABLE (UNAME => '"SAPR3"', ORIG_TABLE => '"PCL2"', INT_TABLE => '"PCL2#$"'); END;'
    ORA-42011: error occurred while completing the redefinitionORA-12008: error in materialized view refresh path
    ORA-01400: cannot insert NULL into ("SAPR3"."PCL2#$"."CLUSTD")
    ORA-06512: at "SYS.DBMS_REDEFINITION", line 82
    ORA-06512: at "SYS.DBMS_REDEFINITION", line 1522
    ORA-06512: at line 1


Read more...

Environment

  • Oracle 11.2.0.2
  • SAP ERP 6.0 / NW 7.01
  • HPUX_IA64
  • Brtools 7.20

Product

SAP enhancement package 3 for SAP ERP 6.0

Keywords

KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.