ora-02158：创建索引选项无效
Hi BI experts, I receive this ORA-02158: invalid CREATE INDEX option error message in tcode SM21 on a daily basis. It doesn't produce a short-dump and the cubes are
Creating a Text index fails with the following error:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-20000: Oracle Text error:DRG-50857: oracle error in drvxtab.create_index_indexesORA-02158: invalid CREATE INDEX optionORA-06512: at "CTXSYS.DRUE", line 160ORA-06512:...
求翻译:ORA-02158: invalid CREATE INDEX option是什么意思?待解决 悬赏分:1 - 离问题结束还有 ORA-02158: invalid CREATE INDEX option问题补充:匿名 2013-05-23 12:21:38 ORA-02158:无效的CREATE INDEX选项 匿名 2013-05-23 12:23:18 ora-02158:创建索引选项无效 匿名 2013-05-23 12:24...
select owner,object_name,object_type from dba_objects o where status = ‘INVALID’ and owner = ‘GZDQMP’ and o.OBJECT_TYPE=’VIEW’;解决是重新编译。 ORA-04065:未执行,已更改或删除stored procedureXXX(过程名) 错误说明:同一个过程中调用了多过程,先跑的过程中有DROP表后重建的操作,DROP表的操作...
select owner,object_name,object_type from dba_objects o where status = 'INVALID' and owner = 'GZDQMP' and o.OBJECT_TYPE='VIEW';解决是重新编译。ORA-04065:未执行,已更改或删除stored procedureXXX(过程名)错误说明:同一个过程中调用了多过程,先跑的过程中有DROP表后重建的操作,DROP表的操作导致后...
Action:Specify at least one ALTER USER option and try again. ORA-02158: invalid CREATE INDEX option Cause:An option other than PCTFREE, INITRANS, MAXTRANS, NOSORT, STORAGE, or TABLESPACE was specified. Action:Specify one of the valid CREATE INDEX options and try again. ...
Action: Specify at least one ALTER USER option. 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 GLOBAL was specified. ...
select owner,object_name,object_type from dba_objects o where status = 'INVALID' and owner = 'GZDQMP' and o.OBJECT_TYPE='VIEW';解决是重新编译。ORA-04065:未执行,已更改或删除stored procedureXXX(过程名)错误说明:同一个过程中调用了多过程,先跑的过程中有DROP表后重建的操作,DROP表的操作导致后...
ORA-00901: 无效 CREATE 命令ORA-00902: 无效数据类型ORA-00903: 表名无效英文解析:invalid table name错误解析:例如动态SQL用绑定变量不能传参做表名,如果传参做表名就会触发这个错误代码案例:declarevc_sql varchar2(100);vc_tablename varchar2(100):='dual';...