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: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 15 Dec 2005 13:08:09 -0800
Message-ID: <1134680882.915897@jetspin.drizzle.com>


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

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Dec 15 2005 - 15:08:09 CST

Original text of this message

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