Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with function based index on timestamp

Re: Problem with function based index on timestamp

From: Björn Wächter <bwc_at_p3-solutions.de>
Date: Fri, 16 Dec 2005 11:01:34 +0100
Message-ID: <40fhmdF1agkkrU1@news.dfncis.de>


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 Received on Fri Dec 16 2005 - 04:01:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US