Skip to Content
author's profile photo Former Member
Former Member

ECC 6.0 Ehp4 to Ehp6: Renaming table REPOSRC not allowed

Hi,

I am trying to upgrade a customer's sandbox system (ECC 6.0 Ehp4 SPS08 on Solaris 10, Oracle 11.2.0.3) to Ehp6 using Software Update Manager 1.0 SP5. During the MAIN_SWITCH/EU_SWITCH phase, I encounter the following error in SUM:

Severe error(s) occured in phase MAIN_SWITCH/EU_SWITCH!
Last error code set: Calling '/sap/D12/SUM/abap/exe/tp' failed with
return code 237, check /sap/D12/SUM/abap/log/TPSQLSTD.OUT for details

The error in TPSQLSTD.OUT points to /sap/D12/SUM/abap/log/TPSQLSTD.OU5
which shows the following:

This is tp version 380.03.82 (release 720, unicode enabled)
ERROR: Statement: RENAME "REPOSRC" TO "REPOSRC~~OLD"
ERROR: SQL ERROR 26563: ORA-26563: renaming this table is not allowed

At the moment I am unable to login to the ECC instance and the shadow instance (probably because of the switch over). Is there anything I can do to resolve this issue?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Nov 22, 2012 at 05:00 PM

    Hi,

    Error ORA-26563 means that this table is replicated, an updatable
    snapshot table or the master table of a snapshot for which a snapshot
    log has been created. It is not possible to rename a snapshot table,
    therefore you will need to drop the snapshot on this table.

    To drop snapshot on the table , you can execute in sqlplus:
    drop snapshot log on sap<SID>.<tablename>

    For more details, please refer Oracle Metalink note 102695.1.

    Regards,

    Aidan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Doug,


      ORA-26563 happens in case of an attempt to rename a replicated table, an updatable snapshot table or the master table of a snapshot for which a snapshot log has been created. When you create a snapshot log Oracle creates an MLOG$ table to store changes made to the base table. Renaming the base table fails because of the relationship between the base table and the MLOG$ table.


      Regards,

      Sachin

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.