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 ONE Support launchpad (Login required).

Search for additional results

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