Re: Problem with function based index on timestamp

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 16 Dec 2005 10:20:02 -0800
Message-ID: <1134757193.901582@jetspin.drizzle.com>

Björn Wächter wrote:
> DA Morgan wrote:
>

>> 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.

>
>
> I stopped the server, changed the spfile and restarted.
> But the problem is still the ame :-(
>
> Björn

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.

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

Received on Fri Dec 16 2005 - 12:20:02 CST