Re: Problem with function based index on timestamp

>
>
> Try the following:
>
> col name format a30
> col value format a30
> select name, value from v$parameter
> where name like '%query%';
>
> Do you get this?
> NAME VALUE
> ------------------------------ --------
> query_rewrite_enabled TRUE
> query_rewrite_integrity TRUSTED
>
> If so ... post the DDL for the table and
> the DML of the query.

This is my result:

SQL> col name format a30
SQL> col value format a30
SQL> select name, value from v$parameter where name like '%query%';

NAME                           VALUE
------------------------------ ------------------------------
query_rewrite_enabled          TRUE
query_rewrite_integrity        TRUSTED

SQL> What i did is:

Connected to:
Oracle Database 10g Release 10.1.0.4.0 - Production

SQL> CREATE TABLE A ( TS TIMESTAMP(3) WITH LOCAL TIME ZONE ); Table created.

SQL> CREATE INDEX IDX_B ON A (TO_NUMBER(TO_CHAR(TS,'YYYYMMDD'))); Index created.

SQL> select * from A;
select * from A

               *
ERROR at line 1:
ORA-03113: end-of-file on communication channel

SQL> Björn Received on Tue Dec 20 2005 - 08:45:35 CST