Re: Problem with function based index on timestamp

From: Björn Wächter <bwc_at_p3-solutions.de>
Date: Fri, 16 Dec 2005 00:17:24 +0100
Message-ID: <40ebuiF19srd0U1@news.dfncis.de>

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
Received on Thu Dec 15 2005 - 17:17:24 CST