1765619 - ORA-00922: missing or invalid option

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

install, installation, migrate, SCHMEMAID, INS, KBA , KBA , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , Problem