Urgent! - Problem during Conversion of SAP datadictionary table...

[Former Member]

Hello All,

When using "Database utility" on a custom table we have encountered a hard error.

Request "Adjust" - Error in step 2 - see object log and analysis

The object log shows:

Begin step ZTABLE-STEP2:                          
sql:                                                       
RENAME "ZTABLE" TO "QCMZTABLE"              
ORA-26563: renaming this table is not allowed              
DDL time(___1): ........31 milliseconds                    
The SQL statement was not executed                         
Renaming of table ZTABLE to ZTABLE failed
Error in step ZTABLE-STEP2

Could any of you advice on what might be the problem is. Now the table could not be converted as it comes till the adjustment step and fails with ORA-26563

[Former Member]

Hi,

Go to SE14

Give the table name..

In the menu..EXTRAS -> DATABASE OBJECT -> CHECK..

Check If the database is consistent with the abap dictionary..

Thanks,

Naren

[Former Member]

Utilities -> Database object -> Check shows

  Database object for ZTABLE is consistent   

.... Here it goes on to list the fields of the db table, datatype, length etc ..............

  Fields: Consistent with the runtime object   

  Indexes: Consistent with DDIC   
  
.... Here it goes on to show that indexes are on db......

Also check and display runtime object shows that the object is consistent.

I am not able to understand one thing here, why is it trying to rename the table during Adjust step?

Any more suggestions please

[Former Member]

Hi,

I believe to adjust the database and to retain the existing data..SAP copies the data into a temporary table and adjust the table...Then copies from the temporary table to the ztable..

Is your table active in SE11?

Thanks,

Naren