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 for Oracle , 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.