1765619 - ORA-00922: missing or invalid option | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1765619 - ORA-00922: missing or invalid option

Symptom

This issue occurs during the import phase of a System Copy.

  • The import_monitor.log will show something like the following:
ERROR: 2012-05-16 08:27:04 com.sap.inst.migmon.LoadTask run
Loading of 'SAPNTAB' import package is interrupted with R3load error.
Process '/usr/sap/DM3/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4102 -l SAPNTAB.log -stop_on_error' exited withturn code 2.
For mode details see 'SAPNTAB.log' file.
  • The logs for the package itself (eg. SAPNTAB.log) will contain something like the following
DbSl Trace: ORA-00922 occurred when executing SQL stmt (parse error offset=5636096)
(DB) ERROR: DDL statement failed 
 (CREATE TABLE "SVERS" ( "VERSION" VARCHAR2(216) DEFAULT ' ' NOT NULL  ) TABLESPACE PSAP@SCHEMAID@  STORAGE (INITIAL 16384 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) ) 
 DbSlExecute: rc = 99
  (SQL error 922)
  error message returned by DbSl:
ORA-00922: missing or invalid option
(DB) INFO: disconnected from DB
  • You could also see the following error:
DbSl Trace: ORA-2158 occurred when executing SQL stmt (parse error offset=224)
(DB) ERROR: DDL statement failed
 (    CREATE UNIQUE INDEX "/BIC/B0000848000~0" ON "/BIC/B0000848000"          ("REQUEST",           "DATAPAKID",           "PARTNO",           "RECORD")        LOCAL        PCTFREE 10        INITRANS 002        TABLESPACE PSAP@SCHEMAID@    NOCOMPRESS    STORAGE (INITIAL     0000000016 K                 NEXT        0000000016 K                 MINEXTENTS  0000000001                 MAXEXTENTS  UNLIMITED                 PCTINCREASE 0000                 FREELISTS   001) PARALLEL )
 DbSlExecute: rc = 99
  (SQL error 2158)
  error message returned by DbSl:
ORA-02158: invalid CREATE INDEX option
(DB) INFO: disconnected from DB

Read more...

Keywords

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