SAP Knowledge Base Article - Preview

2378989 - ORA-01455 while running program SMIGR_CREATE_DDL


You are running program SMIGR_CREATE_DDL on an Oracle database and get the following type of errors, like:


Failed to create storage parameters for table: <TABLE_NAME>


Error while creating DDSTORAGE entries for table <TABLE_NAME>


Furthermore in SM21 ORA-01455 errors are reported:
ORA-01455: converting column overflows integer datatype


You can also check if there are large numbers (>2147483647) in columns INSERTS, UPDATES, DELETES in table DBA_TAB_MODIFICATIONS for these tables.

SQL> select inserts, updates, deletes from DBA_TAB_MODIFICATIONS where table_name = '<TABLE_NAME>';



SAP NetWeaver BW with Oracle database


SAP NetWeaver all versions


system_copy system copy migration se38 BI0 BIC , KBA , BC-DB-ORA-SYS , Database Interface / DBMS , BW-SYS-DB-ORA , BW 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.