SAP Knowledge Base Article - Preview

2215546 - Software Provisioning Manager error: ORA-02220: invalid MINEXTENTS storage option value

Symptom

Database import of system copy using Software Provisioning Manager (SAP Note #1680045) failed in the step ABAP Import. The failed package-log in sapinst_instdir contains the following lines:

...

DbSl Trace: Error 2220 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-02220 occurred at SQL stmt (parse error offset=323)
(DB) ERROR: DDL statement failed
 (   CREATE            INDEX "<tablename>~<#>0" ON "<tablename>"        (""<tablename>")        LOCAL        PCTFREE 10        INITRANS 002        TABLESPACE PSAPSR3FACT      NOCOMPRESS     STORAGE (INITIAL     0000000000 K                 NEXT        0000000016 K                 MINEXTENTS  0000000000                 MAXEXTENTS  0000000000                 PCTINCREASE 0000                 FREELISTS   001) )
 DbSlExecute: rc = 99
  (SQL error 2220)
  error message returned by DbSl:
ORA-02220: invalid MINEXTENTS storage option value
(DB) INFO: disconnected from DB

...


Read more...

Environment

System copy using Software Provisioning Manager tool with R3load procedure on Oracle DB.

All SAP System based on SAP NetWeaver 7.0 and higher

Product

SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

KBA , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , BC-DB-ORA , 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.