Re: Problem with function based index on timestamp

Björn Wächter wrote:
> Oracle 10g 10.1.0.4 on Linux
> query_rewrite_enabled=FALSE
> query_rewrite_integrity=enforced
>
>
>
> DA Morgan wrote:
>

>> Björn Wächter wrote:
>>
>>> executing in sqlplus I get:
>>>
>>> SQL> select * from a;
>>> select * from a
>>>               *
>>> ERROR at line 1:
>>> ORA-03113: end-of-file on communication channel
>>>
>>>
>>> viewing the data of the table in Toad I get:
>>> ORA-00932: inconsistent datatypes: expected NUMBER got -
>>>
>>>
>>> Björn
>>
>>
>>
>> What version of Oracle?
>> What is the value in v$parameter for:
>> query_rewrite_enabled
>> and
>> query_rewrite_integrity

Please do not top post.

Change parameters to:
query_rewrite_integrity=TRUSTED
query_rewrite_enabled=TRUE

Recreate your SPFILE.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)