8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Function-Based Indexes


cachitogoku said...

Hi Tim, you don't specify the values of the parameters
"The QUERY_REWRITE_INTEGRITY and QUERY_REWRITE_ENABLED parameters must be set "

jreyes@dazasoftware. said...

Hi Tim, you don't specify the values of the parameters
"The QUERY_REWRITE_INTEGRITY and QUERY_REWRITE_ENABLED parameters must be set "

Jumpers said...

The values are specified above the permissions.

ben said...

i get the error ORA00907: missing right parenthesis when i try to create the following function-based index:

CREATE INDEX UIMSMGR.DEL_DISC_RPT_N2 ON UIMSMGR.DEL_DISC_RPT (TO_CHAR(DEL_CUST_SVCORD_NUM)) tablespace doc_idx;

We are using Oracle 8.0.6.3.0

Please help.

Ben.Buckley@pnmresources.com

Reshma said...

Thank you....!!!
It helped me a lot...!!

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.