WebNov 15, 2007 · When I try to create an index:CREATE INDEX IDOBJDEFN_IDX ON NETOBJECT (IDOBJDEFN) PARAMETERS ('tablespace=sdsidxfile sdo_rtr_pctfree=20 INITIAL=655360 NEXT=65536 PCTINCREASE=0'); I get ERROR at line 1: ORA-02158: invalid CREATE INDEX option Anybody knows why?. Thanks. Locked Post Locked due to … WebApr 25, 2024 · The problem is that the DBMS_METADATA.GET_DDL returns invalid syntax for an index created. So, during the index creation, both the NOLOGGING and LOGGING keywords are visible in the DDL. For more information on this known Oracle 11gR2 issue, see Oracle Problem [ID 1066635.1]. Solution or Workaround
ORA-02158: invalid CREATE INDEX option - Make DBA Life Easy
WebORA-02158: invalid CREATE INDEX option (DB) INFO: disconnected from DB /usr/sap/ABQ/SYS/exe/run/R3load: job finished with 1 error (s) … WebCode: ORA-02158: Description: invalid CREATE INDEX option Cause: An option other than COMPRESS, NOCOMPRESS, PCTFREE, INITRANS, MAXTRANS, STORAGE, TABLESPACE, PARALLEL ... smallcakes south barrington il
[PL/SQL]EXECUTE IMMEDIATE CREATE INDEX is failing …
WebApr 21, 2009 · It doesn't produce a short-dump and the cubes are perfect ie. no problem with the data loads as well as the indexes. The documentation for system log message says : Access to the database system has returned an SQL code indicating that WebORA-02158: invalid CREATE INDEX option.. Answer / guest Cause: An option other than COMPRESS, NOCOMPRESS, PCTFREE, INITRANS, MAXTRANS, STORAGE, TABLESPACE, PARALLEL, NOPARALLEL, RECOVERABLE, UNRECOVERABLE, LOGGING, NOLOGGING, LOCAL, or GLOBAL was specified. Action: Choose one of the valid CREATE INDEX options. WebFeb 13, 2013 · sql error: ora-02158 invalid create index option *cause: An option other than COMPRESS, NOCOMPRESS,PCTFREE,INITRANS, MAXTRANS,STORAGE,TABLESPACE,PARALLEL, NOPARALLEL,RECOVERABLE,UNRECOVERABLE, LOGGING,NOLOGGING,LOCAL OR … smallcakes south barrington