SAP Knowledge Base Article - Preview

2378989 - ORA-01455 while running program SMIGR_CREATE_DDL

Symptom

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>

OR

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>';


Read more...

Environment

SAP NetWeaver BW with Oracle database

Product

SAP NetWeaver all versions

Keywords

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.